CICA 1994 April/CICA Shareware for Windows CD-ROM (Walnut Creek CD-ROM)(April 1994).ISO/win3/access/access_l.exe/ACC9312.TXT

Text File | 1994-01-07 | 230KB | 5,366 lines

=========================================================================
Date:         Wed, 1 Dec 1993 08:11:43 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jon O'Donnell <[e-mail]>
Subject:      Re: Finding differences between two tables...

Whey you set up your query that joins the two tables by name, click or
double-click the line connecting the two fields in the query window and an
option list will appear to do what you want.

jon
[e-mail]
=========================================================================
Date:         Wed, 1 Dec 1993 06:16:21 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Tri M Pham <[e-mail]>
Subject:      OLE link from MS Write to Access

   Hello,

I think that my previous posting did not work. So, here it is again if it is a
 FAQ
please tell me where to find the answer.  I am trying to link an OLE field to a
MS Write file. This is what I have done:

- Create a table with OLE field.
- Using Wizard Form create a form.
- Select OLE field; then select Edit.
- Another screen was displayed with only MS Graph, Package, Paintbrush Picture,
  and Sound.
- However, when I press File (button) there was another window where I can
  select other file types; I select the document that I want and press OK.
- But I got error: "Invalid source application name".

I am very new at Access and Window. Can you please help and tell me what
I am doing wrong. Also, can a function/procedure be written to perform the
linking task? Can you please send examples? Thank you very much for your time.

   Regards,

   Tri Pham
=========================================================================
Date:         Wed, 1 Dec 1993 06:46:37 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: OLE link from MS Write to Access
In-Reply-To:  <[e-mail]> from "Tri M Pham" at Dec 1,
              93 06:16:21 am

Tri,

You are way, way out of my area of expertise, but since no one else is
trying to help, I will (blind leading the blind).

I _think_ your problem is that MS Write is not registered with the
system OLE server.  There is also a good possibility, that as a "give
away" application, it is not OLE 2.0 compatible.  I have searched the
Knowledge Base, and Windows Help, and haven't found anything else that
is much more helpful.

You need to load Word, WordPerfect, or another application that works
with OLE, test that (it will work), and then work backwards from there.

Good luck.

John
[e-mail]
=========================================================================
Date:         Wed, 1 Dec 1993 12:04:53 CST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Converted from PROFS to RFC822 format by PUMP V2.2X
From:         Stace Cameron <[e-mail]>
Subject:      Access as Front end to MS SQL Server Error

I have to admit I am a complete novice when it comes to Microsoft Access.
I am attempting to use Access to view the sample PUBS database that resides
on our recently acquired MS SQL Server. Following are the steps I have
tried and the resulting error message. I would appreciate pointers as to
where I am going wrong. Thanks.

1. Access is installed on the network.
2. Ran setup /n to install Access on my workstation.
3. Ran Microsoft ODBC setup to install SQL SERVER ODBC DRIVER
4. Start up Access
5. Select New Database called it PUBS in my c:\ACCESS directory
6. Picked Attach Table
7. Picked <SQL Database> as the Data Source
8. Picked the ODBC driver as the SQL Data Source
9. Logged in the SQL Server as SA
10. The list of tables in the remote database is displayed
11. Pick the first one and click Attach and then get:

Reserved Error (-7745): There is no message for this error.

Stace Cameron                           BITNET: GH0234@SPRINGB
Director                              INTERNET: [e-mail]
Office of Administrative Computing
Southern Illinois University School of Medicine    Phone: [phone]
PO Box 19230, Springfield IL 62794-9230              FAX: [phone]
=========================================================================
Date:         Wed, 1 Dec 1993 13:00:00 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Ellington, Robert W (Bob)" <[e-mail]>
Subject:      Limit to # Attached Tables?

I am using ODBC to attach Informix tables in Access 1.1, and I had
eliminated all the "Out of Memory" Errors for the longest time.  Then in the
last few days I attached 4 more Informix Tables to my database and now I am
getting the "Out of Memory" message again.  Someone said something the other
day about Access (or Windows programs) grabbing only 640Kb blocks to work
in.  My database just now increased in size to over 640 kb (compacted) in
disk size, and is all code & forms, no data stored in it.  Have I exceeded a
sacred size for code & forms, or have I possibly exceeded a limit to the
number of attached tables you can use?  Are there such limits?  Is there a
way around this 640kb block limit (besides NT)?  Is it grabbing larger
sections of conventional memory now that the .mdb is larger?
Am I asking too many questions? (Don't answer that.)

Thanks for any assistance
Bob
=========================================================================
Date:         Wed, 1 Dec 1993 11:38:56 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         DARRYL BRAATEN <[e-mail]>
Subject:      field changing on date

in a data base that we are devoloping there is a priority field that must chang
e after seven days.  There is a date field that records the date the work order
 was created the update will be based on how many days have past since this dat
e. What is the best(easiest) way to do this.

  Thanks in advance.

    ttfn
         Darryl Braaten
             [e-mail]
=========================================================================
Date:         Wed, 1 Dec 1993 15:20:04 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Limit to # Attached Tables?
In-Reply-To:  <[e-mail]> from "Ellington,
              Robert W" at Dec 1, 93 01:00:00 pm

Bob,

Can't answer your ODBC question, but be assured, you can run MDB's much
larger than 640 K.

I believe the limit in 1.1 is 128 Meg.

John
[e-mail]
=========================================================================
Date:         Wed, 1 Dec 1993 18:54:31 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Bill Stewart <[e-mail]>
Subject:      Re: Limit to # Attached Tables?

The 640k block has to deal with system resources for any windows
application.  there are only so many things to go around.  It's my guess
that as a database grows graphically and table-wise it starts to tap more
and more into the 640k of resources.  Just because your DB is 640+ does not
mean that it is eating up all of those resources.  I wonder if the memory
problem you and I share is a glitch in Access.  maybe 2.0 will address this
problem and the idea of using the MDI to have multiple databases open.

------------------------------------------------------
Bill Stewart
Gendale Community College
6000 W. Olive Ave
Glendale AZ. 85302
------------------------------------------------------
=========================================================================
Date:         Wed, 1 Dec 1993 22:10:17 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: Limit to # Attached Tables?
In-Reply-To:  Message of Wed,
              1 Dec 1993 15:20:04 -0800 from <[e-mail] M>

Max database size in 1.0 was 128 MB--max in 1.1 is 1 Gigabyte.

See the "What's New in Access 1.1" readme that the upgrade installed
in your Access group.

Cheers,
-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Thu, 2 Dec 1993 09:30:28 GMT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Anthony Gibbons <[e-mail]>

Hi All,
        Maby someone out there can help me. I am importing Btrieve tables into
Access 1.1, however Btrieve arrays do not seem to import correctly they are
corrupted. Any ideas ?

Thanks,
Anthony Gibbons
[e-mail]
=========================================================================
Date:         Thu, 2 Dec 1993 08:46:21 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jon O'Donnell <[e-mail]>
Subject:      Btrieve Arrays

I did not think relational databases could handle arrays.  What is normally
done is to turn the array into a new table with the key of the the new table
being a combination of the key to the old table plus a row number or array
element number.  This may require an intermediate step?  Unfortunately, I don't
know anything about Btrieve...

Hope this helps.

Jon
[e-mail]
=========================================================================
Date:         Thu, 2 Dec 1993 08:35:14 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "John A. Olson" <[e-mail]>
Subject:      Re: Finding Differences between 2 tables

This Function creates a query whose result is the same as the logical Table
A - Table B. As it is currently written, the two Tables must have 1 common
Key between them with the same name.

Syntax:

dummy = MakeQuery_TableA_minus_TableB (QueryName As String, Table_A As
String, Table_B As String, Key As String)

QueryName ...... The name you wish to give this Query
Table_A ........... The name of the first Table
Table_B ........... The name of the second Table
Key .................. The name of the Key Field the two Tables have in common

Function MakeQuery_TableA_minus_TableB (QueryName As String, Table_A As
String, Table_B As String, Key As String)
'
'This Function creates a query whose result is the same as the logical
'Table A - Table B. The two Tables must have 1 common Key between them.
'
Dim db As Database, q  As QueryDef, sql As String, ssquerylist As Snapshot
Set db = CurrentDB()
Set ssquerylist = db.ListTables()

Do Until ssquerylist.eof
   If ssquerylist.name = QueryName Then
      If ssquerylist.tabletype = DB_QUERYDEF Then
        DoCmd SelectObject A_Query, ssquerylist.name, True
        DoCmd DoMenuItem 1, 1, 4  'delete it!
      End If
   End If
   ssquerylist.MoveNext
Loop

sql = "SELECT  DISTINCTROW [" & Table_A & "].*"
sql = sql & " FROM [" & Table_B & "], [" & Table_A & "],"
sql = sql & " [" & Table_A & "] LEFT JOIN [" & Table_B & "] ON [" & Table_A
& "].[" & Key & "] = [" & Table_B & "].[" & Key & "]"
sql = sql & " WHERE ([" & Table_A & "].[" & Key & "] Not In ([" & Table_B &
"].[" & Key & "]))"
sql = sql & " WITH OWNERACCESS OPTION;"

Set db = CurrentDB()
Set q = db.CreateQueryDef(QueryName, sql)

End Function


I'm sure that this can be improved upon, but due to a lack of "play time" I
haven't done it yet. :)

Good Luck!

John

[e-mail]
=========================================================================
Date:         Thu, 2 Dec 1993 08:12:59 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "[e-mail]" <[e-mail]>
Subject:      Programming: Accessing a string character by character

I am creating a module that has a couple of input strings via
the parameter list.  What I would like to do is access the string one
character at a time.  I found a round-about way by using the MID function
and a for loop.  Is there some easier way???

        MY FOR LOOP:

                        For Index1 = 1 To Len(LastName)
                           TempChar = Mid(LastName, Index1, 1)
                                ..
                                ..
                                ..
                        Next

Thanks for your help.

Jason Beatty
Information Technology
Metropolitan State College of Denver

[e-mail]
=========================================================================
Date:         Thu, 2 Dec 1993 09:34:11 -0500
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Margaret Redding <[e-mail]>
Subject:      Re: OLE link from MS Write to Access

>
>   Hello,
I looked in my Windows book and I think I found the answer to your
problem. Strange as it may seem, Access does not support OLE.
You can import objects into Access, and transfer objects between tables
etc. but you cannot set up a link to MS Write.

One clue I got was by looking in my WIN.INI file. In the section
"embedded" there is a list of programs that can serve as servers, Access
is not among them. Furthermore, there is no mention of linking and
embedding tables etc. to client programs.

You might be able to do something with Object Packager.
 I'll try to look into that later. The power is down at the moment, and
I'm doing this on my notepad.

Margaret

 >
>I think that my previous posting did not work. So, here it is again if it is a
> FAQ
>please tell me where to find the answer.  I am trying to link an OLE field to a
>MS Write file. This is who I have done:
>
>- Create a table with OLE field.
>- Using Wizard Form create a form.
>- Select OLE field; then select Edit.
>- Another screen was displayed with only MS Graph, Package, Paintbrush Picture,
>  and Sound.
>- However, when I press File (button) there was another window where I can
>  select other file types; I select the document that I want and press OK.
>- But I got error: "Invalid source application name".
>
>I am very new at Access and Window. Can you please help and tell me what
>I am doing wrong. Also, can a function/procedure be written to perform the
>linking task? Can you please send examples? Thank you very much for your time.
>
>   Regards,
>
>   Tri Pham
>
>

--
Margaret Redding  [e-mail]
Ottawa, Ontario
CANADA
=========================================================================
Date:         Thu, 2 Dec 1993 10:47:25 CST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Richard Moldwin <[e-mail]>
Subject:      OLE

 >
>I think that my previous posting did not work. So, here it is
again if it is a
> FAQ
>please tell me where to find the answer.  I am trying to link an
OLE field to a
>MS Write file. This is who I have done:
>
>- Create a table with OLE field.
>- Using Wizard Form create a form.
>- Select OLE field; then select Edit.
>- Another screen was displayed with only MS Graph, Package,
Paintbrush Picture,
>  and Sound.
>- However, when I press File (button) there was another
window where I can
>  select other file types; I select the document that I want and
press OK.
>- But I got error: "Invalid source application name".
>
>I am very new at Access and Window. Can you please help
and tell me what
>I am doing wrong. Also, can a function/procedure be written
to perform the
>linking task? Can you please send examples? Thank you very
much for your time.
>
>   Regards,
>
>   Tri Pham
>
>
There are 2 points here that need to be clarified concerning
OLE.  First, very few programs can act as an OLE server (i.e.
supply linked or embedded info to an OLE client window).
Access can have OLE client fields in the database (this is not
yet supported in the Visual Basic 3.0 vesion of data access).
As far as I know, MS Write can only act as an OLE client--you
cannot embed or link an MS Write document into an Access
OLE client field.  However, many of the major windows word
processors (e.g. Ami Pro, WinWord) can act as an OLE Server.
This server ability is very primitive in that no Windows word
processor actually will display text in an OLE client field (I
don't know about Winword 6.0).  All that you will see is an icon
that represets the document.
I hope that clarifies the issue.
--Rich Moldwin
=========================================================================
Date:         Thu, 2 Dec 1993 10:59:59 CST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Richard Moldwin <[e-mail]>
Subject:      System Resources

I would like to clarify a few things about system resources.  My reference is
the windows resource kit, page 251.
"Both GDI and USER have storage areas called heaps, which are limited to 64K
in size.  GDI has a local heap; USER has a menu heap and a user heap, each
limited to 64K in storage space."  If you run the windows resouce monitor
from the kit, you will know when access will get into trouble.  Especially
when GDI gets below about 20%, you will run into erratic behaviour with just
about any application.  Do not run Access in this situation; close all other
applications first to recover resources.  Some applications will close and
not release system resources (e.g. Excel).  In this case, you should close
windows and restart it before loading any resouce intensive application like
Access.  I personally will not load any new application when resources are
below about 40-50% (GDI) in order to avoid problems.  The resource problem
will ? be fixed when we get a 32-bit (NT/Chicago-compatable) version af
Access. If you ignore your system resources, you are almost guaranteed to
have problems, especially with access, which can draw more resources whenever
it loads a new form or query or report).
--Rich Moldwin
--U. Chicago Hospitals
--Pediatric Heme/Onc
=========================================================================
Date:         Thu, 2 Dec 1993 12:09:55 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Louis Jezsik <[e-mail]>
Subject:      Use a form to enter data in the table?

I have a form with information about publications.  In order to speed
up the data entering I want to use drop down list boxes for such things
as City and Publisher.  After setting it up, I get either #ERROR in the
box or (when I manage to fix it) a list of numbers only.  Fiddling some
more I manage to get it to accept input but it does not go into my
original table but to some quasi table for the form.  What gives?
Thanks for the help!
Louis
[e-mail]
=========================================================================
Date:         Thu, 2 Dec 1993 10:15:50 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Use a form to enter data in the table?
In-Reply-To:  <[e-mail]> from "Louis Jezsik" at Dec 2,
              93 12:09:55 pm

Louis,

I will assume that you are loading the list box from a table, so that
the row source is set to a table name.  You probably have the bound
column set to the key field, which I would guess is a counter.  Those
are the numbers that are appearing!  What you need to do is adjust the
columns and column widths.  If you have two columns, and the key field
is in column 1, set the column widths to 0;1 in or, in cm, 0;2.54 cm.
Then you will see the text (column 2), but when you reference the
control, you will get the value for column 1.

To write the value of the list box to the database, you can do one of
two things:

1)  Write a function that you attach to the OnUpdate property of the
    list box.  Have it copy the value from the list box to a hidden
    (visible = no) that is bound to the underlying table.  Something
    like:

    Function MoveIt()
        Forms![MyForm]![MyHiddenControl] = Forms![MyForm]![MyListBox]
    End Function

2)  Do the same thing with a macro.

Your error message is probably caused by having no row source for the
list box.

john
[e-mail]
=========================================================================
Date:         Thu, 2 Dec 1993 10:22:03 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Programming: Accessing a string character by character
In-Reply-To:  <[e-mail]> from "[e-mail]" at
              Dec 2, 93 08:12:59 am

Jason,

Your method is the common one of processing strings one character at a
time in BASIC.

john
[e-mail]
=========================================================================
Date:         Thu, 2 Dec 1993 14:03:29 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Louis M. Swiczewicz" <[e-mail]>
Subject:      Access Knowledge Base at CICA

The Access Knowledge Base file has been uploaded to CICA. You will
find two files in the upload directory, acc_kb.zip and acc_in.zip.
The acc_kb.zip file is the help system which includes more than
1000 articles that relate to the Microsoft Access for Windows.  The
help file is an updated snapshot of the Knowledge Base as of
September 22, 1993.  It functions quite well without the second
file but does require winhelp.exe.  If you would like full text
search capability of the help file, then you need to download the
acc_in.zip file as well.

Special recognition goes out to John von Colditz
([e-mail]).  Not only does John provide the list with
many helpful hints, he at his own expense next day aired disks
which contained the programs so that I could upload them to CICA
for the list members.  On behalf of the list, I would like to thank
John for his generosity and assistance.



Louis M. Swiczewicz, Ph.D. ([e-mail])
Area Coordinator, Engineering and Technology
Roger Williams University
Bristol, Rhode Island 02809
=========================================================================
Date:         Tue, 30 Nov 1993 07:39:35 +0000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Marty McMahon <[e-mail]>
Subject:      ACCESS KNOWLEDGE BASE PROB.

I have downloaded the Microsoft Access Knowledge base files from the Microsoft
download bulletin board, but cannot get through the decompression system.  It
contains four files: Disk1.dat , Disk2.dat, Build.bat and readme.txt.  The
Build.bat combines the two Diskx.dat files into KB.EXE and then tries to run
KB.EXE.  On three different machines I get  out of memory errorsJ"Program too
big for Memory".  The KB.EXEJDile is 2.7 megs.  Anyone figured out how to get
this to work?

Marty McMahon
=========================================================================
Date:         Thu, 2 Dec 1993 11:23:41 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Corey Lawson <[e-mail]>
Subject:      Re: OLE link from MS Write to Access
In-Reply-To:  <[e-mail]>

On Thu, 2 Dec 1993, Margaret Redding wrote:

Umm...as far as I knew, Write isn't an OLE application...that's why the
link to Write didn't work...

-Corey Lawson
[e-mail]
        or
[e-mail]


>   Hello,
> I looked in my Windows book and I think I found the answer to your
> problem. Strange as it may seem, Access does not support OLE.
> You can import objects into Access, and transfer objects between tables
> etc. but you cannot set up a link to MS Write.
>
> One clue I got was by looking in my WIN.INI file. In the section
> "embedded" there is a list of programs that can serve as servers, Access
> is not among them. Furthermore, there is no mention of linking and
> embedding tables etc. to client programs.
>
> You might be able to do something with Object Packager.
>  I'll try to look into that later. The power is down at the moment, and
> I'm doing this on my notepad.
>
> Margaret
>
=========================================================================
Date:         Thu, 2 Dec 1993 15:14:35 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: OLE link from MS Write to Access
In-Reply-To:  Message of Thu,
              2 Dec 1993 11:23:41 -0800 from <alfalfa@BOOSTER.U. WASHINGTON.EDU>

Yes, Access 1.1 is OLE-compatible (as was 1.0)...the Windows applets
aren't, to the best of my knowledge.

(I just looked at the brochure for Access 1.1 that I picked up at the
Microsoft "Upgrading to a Better Office" seminar the other day.  All
those new products really make me slaver at the mouth...:)

(the real kick was watching the presenter's computer lock up about
three times...she was using pre-release versions and got some friendly
"we've been there" laughs from the audience...)

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Thu, 2 Dec 1993 19:04:51 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Access Knowledge Base at CICA
In-Reply-To:  <[e-mail]> from "Louis M. Swiczewicz" at
              Dec 2, 93 02:03:29 pm

Lou,

Thanks for your kind plug!

I am off to Japan until the 11th of December.  Anyone who "needs" to get
ahold of me can e-mail to my Compuserve address: 71564,2174

On the Knowledge Base, I would strongly suggest getting the index file
too (ACC_IN.ZIP).  It really makes searching the Knowledge Base a
breeze.

I am still trying to clarify the status of the Knowledge Base on
Microsoft's Internet node.

See you again on the 11th.

John
[e-mail]
=========================================================================
Date:         Fri, 3 Dec 1993 00:33:18 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jenny Jacobson <[e-mail]>
Subject:      How do I save reports to an ASCII file?

When I used WAMPUM (a shareware program), I was able to direct my
output to an ASCII file.  I need this capability in ACCESS.

Our mission is to enter citations (records) into ACCESS and output
reports in text files that can be stored electronically at an ftp site
and other electronic storage areas.  Since there are four separate
requiements (formats), we'd like to design four reports and only
need to update the datebase as new information resources become available.


Jenny Jacobson
[e-mail]
=========================================================================
Date:         Fri, 3 Dec 1993 07:39:46 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Stephen Hueners <[e-mail]>
Subject:      Dialing phone from field

There is a Knowledge Base note deailing with this...I got i through Fax back
but can't find original fax to refer to posting number....


The note directs that a control refer to an AB module containing the
following code:

Option Compare Database   'Use database order for string comparisons
Option Explicit

Declare Function OpenComm% Lib "User" (ByVal lpComName$, ByVal wInQueue%,
ByVal wOutQueue%)
Declare Function CloseComm% Lib "User" (ByVal nCid%)
Declare Function WriteComm% Lib "User" (ByVal nCid%, ByVal lpBuf$, ByVal
nSize%)

Const ID_CANCEL = 2
(end declarations)

Function DialNumber ()
    Dim sCommPort$
    Dim sPhoneNumber$
    Dim sDial$
    Dim iWritePort%
    Dim iOpenPort%
    Dim iClosePort%
    Dim iCharCount%
    Dim iStart#
    Dim Response%

'sCommPort$ = "2"
'sPhoneNumber$ = Forms!Address!AreaCode
sPhoneNumber$ = "1878"
sDial$ = "ATDT" & sPhoneNumber$ & Chr$(13)
iCharCount% = Len(sDial)
Debug.Print sDial$

iOpenPort% = OpenComm("2", 1024, 128)
Debug.Print iOpenPort%
If (iOpenPort% < 0) Then
    MsgBox "Unable to Dial Number: Make Sure Nother Devices are using the
Communications Port.", 16, "Error Dial Failed"

End If

iWritePort% = WriteComm(iOpenPort%, sDial, iCharCount%)

If (iWritePort% > 0) Then
    iStart# = Timer

    Do
    Loop Until Timer >= iStart# + 3
    Response% = MsgBox("Pick up Phone and Press OK or Cancel to Quite and
Hang up.", 65, "Dialing Successful")
    If Response% = ID_CANCEL Then
        'Reset Modem and take off line
        iWritePort = WriteComm(iOpenPort%, Chr$(13), 1)
    End If
Else

    MsgBox "Unable to Dial Number: Make Sure Nother Devices are using the
Communications Port.", 16, "Error Dial Failed"

End If




End Function


(Code contains some of my debugging attempts)

Does'nt work for me. Support suggest a port compatiblity problems but
Terminal works fine.

Has anyone been able to succeed using code provided in Knowledge Base??
=========================================================================
Date:         Fri, 3 Dec 1993 10:49:48 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Dialing phone from field

% Does'nt work for me. Support suggest a port compatiblity problems but
% Terminal works fine.

% Has anyone been able to succeed using code provided in Knowledge Base??

I used the material Roger put in his book when it came through --
since I knew it worked I didn't see any reason to try the KB (no
time)

phil
=========================================================================
Date:         Fri, 3 Dec 1993 07:26:29 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Tim King <uswnvg![e-mail]>
Subject:      Preventing NULL Columns

I've noticed in Access that you can't define a column as "NOT NULL" as in
other products.  Of course I'm preventing nulls in a field at the form
level, but I would like the added security of preventing nulls at the
database level.  Anyone know how to do this?

--
Tim King, [e-mail]
US West NewVector Group Inc., Bellevue, Washington
=========================================================================
Date:         Fri, 3 Dec 1993 13:23:26 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Scott F Eggert <[e-mail]>
Subject:      help with oracle connections

I would appreciate some information from people who have worked with both
oracle and access.  I am planning to use access on a pc as a front-end
and oracle as the main database which is on a sun station.  However, I am
not sure that this is the best combination. At the present time, I am very
pleased with access and have developed some applications in it.  This will be
a much larger project, and i want to do it right the first time.

thank you
=========================================================================
Date:         Fri, 3 Dec 1993 12:44:07 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Scott F Eggert <[e-mail]>
Subject:      Re: Preventing NULL Columns
In-Reply-To:  <[e-mail]>; from "Tim King" at Dec 3,
              93 7:26 am

If I am understanding your question properly, all that you have to do is when
you make your table, include "is not null" (not the parens) in the validation
rule.  also, when you make a form and put this piece of the table in it, make
a function that determines if the value is null, using the isnull function,
and if it is null, use a msgbox to tell the user to put something there.
=========================================================================
Date:         Fri, 3 Dec 1993 10:20:09 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Corey Lawson <[e-mail]>
Subject:      Re: Preventing NULL Columns
In-Reply-To:  <[e-mail]>

What about making the field's Default Value (in the field properties
window) check for null values?

-Corey Lawson
[e-mail]
        or
[e-mail]
=========================================================================
Date:         Fri, 3 Dec 1993 14:10:47 CST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Richard Moldwin <[e-mail]>
Subject:      Re: Preventing NULL Columns
In-Reply-To:  Your message of Fri, 3 Dec 1993 07:26:29 -0800

The proper syntax, I think, is "Is Not NULL", not "NOT NULL"
I hope this helps. --Rich
=========================================================================
Date:         Fri, 3 Dec 1993 10:43:10 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "John A. Olson" <[e-mail]>
Subject:      Re: Access as Front end to MS SQL Server Error

>I have to admit I am a complete novice when it comes to Microsoft Access.
>I am attempting to use Access to view the sample PUBS database that resides
>on our recently acquired MS SQL Server. Following are the steps I have
>tried and the resulting error message. I would appreciate pointers as to
>where I am going wrong. Thanks.
>
>1. Access is installed on the network.
>2. Ran setup /n to install Access on my workstation.
>3. Ran Microsoft ODBC setup to install SQL SERVER ODBC DRIVER
>4. Start up Access
>5. Select New Database called it PUBS in my c:\ACCESS directory
>6. Picked Attach Table
>7. Picked <SQL Database> as the Data Source
>8. Picked the ODBC driver as the SQL Data Source
>9. Logged in the SQL Server as SA
>10. The list of tables in the remote database is displayed
>11. Pick the first one and click Attach and then get:
>
>Reserved Error (-7745): There is no message for this error.
>
>Stace Cameron                           BITNET: GH0234@SPRINGB
>Director                              INTERNET: [e-mail]
>Office of Administrative Computing
>Southern Illinois University School of Medicine    Phone: [phone]
>PO Box 19230, Springfield IL 62794-9230              FAX: [phone]
>
>

I had a similar problem when trying to attach to a Btrieve table.  After
many attempts, and a few phone calls to Microsoft, it was discovered that
Access needed to exclusively lock the table for a moment before an
attachment could be made.  I don't know if this is relevant to your problem,
but try making sure no one else is using the table during the time that you
first attach to it.  Once you are attached, you will not have a problem
accessing the data even if someone else is using the table at the same time.
 If this works, or if you find another solution, please post the solution to
the list.  I'm sure others would be interested.

Good Luck!

John

[e-mail]
=========================================================================
Date:         Sat, 4 Dec 1993 15:06:41 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Warning -- original Sender: tag was [e-mail]
From:         [e-mail]
Subject:      Some differences between R:BASE and Access

I'm a new user to Access, and am somewhat adept at R:Base. Can anyone explain
to me maybe the major features of Access, and the Advantages/Disadvantages it
might have over R:base or other major relational Databases?
=========================================================================
Date:         Mon, 6 Dec 1993 10:49:53 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Richard Tkachuck <[e-mail]>
Subject:      Re: help with oracle connections
In-Reply-To:  <[e-mail]>

I can't seem to find a way to change the name of a report or querry once
I have formulated it.  Thus a mis-spelling shows up in my report
listing.  Would rather not re-make the report so to get the name right.

Richard Tkachuck               AskERIC Coordinator
AskERIC:  ERIC Clearinghouse,  030 Huntington Hall
Syracuse University, Syracuse, NY 13210
Phone:  [phone]           FAX [phone]
email:  [e-mail]
=========================================================================
Date:         Mon, 6 Dec 1993 11:41:00 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "John A. Olson" <[e-mail]>
Subject:      Re: help with oracle connections

>I can't seem to find a way to change the name of a report or querry once
>I have formulated it.  Thus a mis-spelling shows up in my report
>listing.  Would rather not re-make the report so to get the name right.
>
>Richard Tkachuck               AskERIC Coordinator
>AskERIC:  ERIC Clearinghouse,  030 Huntington Hall
>Syracuse University, Syracuse, NY 13210
>Phone:  [phone]           FAX [phone]
>email:  [e-mail]
>
>

Question:  What does this have to do with ORACLE connection problem?

John
=========================================================================
Date:         Mon, 6 Dec 1993 10:26:01 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Monty <[e-mail]>
Subject:      W(h)ither Access 2.0

Over the last couple of crazy months, i best recall ive been hearing
occassional,  general references to an Access 2.0. Does anyone know anything
more specific concerning features and projected dates of release?
=========================================================================
Date:         Mon, 6 Dec 1993 13:53:57 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: W(h)ither Access 2.0
In-Reply-To:  Message of Mon, 6 Dec 1993 10:26:01 PST from <3533P@NAVPGS>

There was absolutely no mention of a version 2.0 at the "Upgrading to
A Better Office" MS seminar I attended last week.  Since they were showing
Word 6.0, Powerpoint 4.0, and Excel 5.0 at the time, and just plain ol'
Access 1.1, one has to regretfully assume that it won't be any time soon...

Although Word 6.0 makes it a ton load easier to mail merge from Access!

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Mon, 6 Dec 1993 10:55:43 +0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         al berni <[e-mail]>
Subject:      Re: W(h)ither Access 2.0

On Mon, 6 Dec 1993, Monty wrote:

> Over the last couple of crazy months, i best recall ive been hearing
> occassional,  general references to an Access 2.0. Does anyone know anything
> more specific concerning features and projected dates of release?

It's in beta (or as MS calls it "Test Release") and it is extreemly cool!
As it is I've probably violated some non-disclosure agreement so I better
just shut up - bye.
=========================================================================
Date:         Mon, 6 Dec 1993 14:17:31 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Re: W(h)ither Access 2.0

% There was absolutely no mention of a version 2.0 at the "Upgrading to
% A Better Office" MS seminar I attended last week.  Since they were showing
% Word 6.0, Powerpoint 4.0, and Excel 5.0 at the time, and just plain ol'
% Access 1.1, one has to regretfully assume that it won't be any time soon...

As a rule, Microsoft won't comment on (forthcoming) products until
after they have officially been "announced" -- the announcement is
not only a statement of schedule, but usually formality acknowledging
the existence of such a beast.

And even then, those of us who might be or are on a hypothetical
Beta program are unable to discuss the software.  Technically,
the NDAs for both Borland & Microsoft state you can't discuss
a Beta even after the product is released.

F|o|o|d|f|o|r|t|h|o|u|g|h|t,

phil
=========================================================================
Date:         Mon, 6 Dec 1993 14:31:55 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: W(h)ither Access 2.0
In-Reply-To:  Message of Mon,
              6 Dec 1993 14:17:31 EST from <72410.2162@COMPUSERV E.COM>

And of course, more food for thought...don't forget we have Microsoft
lurkers on this list.

Phil makes a good point.  Shall we start a pool on the product announcement
date?  (Just kidding, just kidding!!!)

Yr hmbl lstownr

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Mon, 6 Dec 1993 11:35:04 PST
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Re: W(h)ither Access 2.0
In-Reply-To:  <[e-mail]>; from "Phil Paxton" at Dec
              6, 93 2:17 pm

> And even then, those of us who might be or are on a hypothetical
> Beta program are unable to discuss the software.  Technically,
> the NDAs for both Borland & Microsoft state you can't discuss
> a Beta even after the product is released.
>
> F|o|o|d|f|o|r|t|h|o|u|g|h|t,
>
> phil

One difference I have noticed is that Borland will often "discuss"
matters of schedule and release with beta testers. Microsoft, on the
other hand, will not. On the other hand, Borland seems to be a bit more
guarded/secretive about its early test releases than Microsoft is.
Information seems to "leak" quite early with new MS products, and not
as much with Borland. Just some observations...

--
TONY HAMILTON ==================================================
 Intel Corporation            | voice: 916-356-3070
  Folsom Engineering Services | mailstop: FM2-17
   PC Applications            | email: [e-mail]
================================================================
=========================================================================
Date:         Mon, 6 Dec 1993 14:54:54 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Scott F Eggert <[e-mail]>
Subject:      oracle-7 drivers for access

Does anyone know if Oracle 7 has drivers for access?  I figure that they
probobly do, but I thought that I might ask...

thanks
[e-mail]
=========================================================================
Date:         Mon, 6 Dec 1993 12:32:51 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John Betz <[e-mail]>
Subject:      Re: W(h)ither Access 2.0

Al-

Please refrain from discussing the Access 2.0 testing release in public
forums. This message clearly violates the NDA you signed and you never
know who may be listening...


John Betz
Access Product Manager
----------
From: al berni  <netmail![e-mail]>
To: Multiple recipients of list ACCESS-L
<netmail!ACCESS-L![e-mail]>
Subject: Re: W(h)ither Access 2.0
Date: Monday, December 06, 1993 10:55AM

On Mon, 6 Dec 1993, Monty wrote:

> Over the last couple of crazy months, i best recall ive been hearing
> occassional,  general references to an Access 2.0. Does anyone know anything
> more specific concerning features and projected dates of release?

It's in beta (or as MS calls it "Test Release") and it is extreemly cool!
As it is I've probably violated some non-disclosure agreement so I better
just shut up - bye.
=========================================================================
Date:         Mon, 6 Dec 1993 15:43:02 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jon Diercks <[e-mail]>
Organization: Anderson University, Anderson, IN
Subject:      Re: W(h)ither Access 2.0
In-Reply-To:  from "John Betz" at Dec 6, 93 12:32 (noon)

> Al-
>
> Please refrain from discussing the Access 2.0 testing release in public
> forums. This message clearly violates the NDA you signed and you never
> know who may be listening...
>
> John Betz
> Access Product Manager

How about that, Al?  You figured out how to get a response from MS!  :->

--
 \on \                     [e-mail]              Computing Services
\_\ <_\iercks                                           Anderson University
   >                                                           Anderson, IN
  ---  ...'Politically Correct' is an oxymoron. (Merry Christmas, Bill!)
=========================================================================
Date:         Mon, 6 Dec 1993 16:34:24 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Re: W(h)ither Access 2.0

% One difference I have noticed is that Borland will often "discuss"
% matters of schedule and release with beta testers. Microsoft, on the
% other hand, will not. On the other hand, Borland seems to be a bit more
% guarded/secretive about its early test releases than Microsoft is.
% Information seems to "leak" quite early with new MS products, and not
% as much with Borland. Just some observations...

And now Borland has gone to registration numbers for Beta products.  This
is one level behind the security of Microsoft's Beta:  runtime passwords.

Whilst this won't stop the sharing of betas, it will help track down
who is leaking (sometimes).

Until horror stories are made public of people who have been blacklisted
(or even entire companies), I don't think there will be a decrease in
the number of leaks...

Mind you, I'm not advocating the sharing of prereleases...
=========================================================================
Date:         Mon, 6 Dec 1993 16:17:31 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Bob Hambuchen <[e-mail]>
Subject:      Re: W(h)ither Access 2.0

Wonder of wonders....

The first participation I can remember on this list from Microsoft is
from none less than the Access Project Manager, chiding someone for
saying the project is extreemly cool!

Thanks a lot John Betz!
=========================================================================
Date:         Mon, 6 Dec 1993 14:06:37 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Tim King <uswnvg![e-mail]>
Subject:      Re: W(h)ither Access 2.0
In-Reply-To:  <[e-mail]> from "John Betz" at Dec 6,
              93 12:32:51 pm

Thus spake John Betz:
> Please refrain from discussing the Access 2.0 testing release in public
> forums. This message clearly violates the NDA you signed and you never
> know who may be listening...

OK, so you are listening.  How about contributing?  We get great
contributions on the Visual Basic list from some of my Microsoft
neighbors down the street.

--
Tim King, [e-mail]
US West NewVector Group Inc., Bellevue, Washington
=========================================================================
Date:         Mon, 6 Dec 1993 17:20:32 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Thornton Prime <"Thorton_~Prime_at_lmu-acad1"@LMUMAIL.LMU.EDU>
Subject:      Re: Preventing NULL Columns

>I've noticed in Access that you can't define a column as "NOT NULL" as in
>other products.  Of course I'm preventing nulls in a field at the form
>level, but I would like the added security of preventing nulls at the
>database level.  Anyone know how to do this?

I use a query that has "Not Is Null" in the criteria for the filed I want to
filter out nulls for.

Thornton Prime
Loyola Marymount University
=========================================================================
Date:         Mon, 6 Dec 1993 23:53:39 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jenny Jacobson <[e-mail]>
Subject:      Re: W(h)ither Access 2.0

According to "Special Edition: USING ACCESS(tm) FOR WINDOWS(tm)"
published by QUE, copyright 1993:

    Look for Version 2.0 of Access in the Spring of 1994.  Microsoft
    typically issues major upgrades to its Windows applications at
     15-18 month intervals.

It goes on to describe some of the changes we can expect in version 2.0
based on comments by beta testers.

The changes are described on page 1071.

Jenny Jacobson
[e-mail]
=========================================================================
Date:         Tue, 7 Dec 1993 00:36:22 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jenny Jacobson <[e-mail]>
Subject:      Re: How do I save reports to an ASCII file?

Thanks to all who wrote to me personnaly and offered their ideas.
I've solved the problem for our situation.  A posting on WordPerfect
discussion grouop gave me a clue to follow.  Here's what I do:

1) export the table(s) in ASCII-delimited format.
2) Use Word Perfect to convert the file to a Merge-Data file.
3) Create Merge Forms to process the records in Word Perfect.
4) Sort the Merge-Data file(s) so my output will be in sorted order.
5) Print the report(s).

I'm using WordPerfect 6.0 for Windows.  Next, I'm going to design input
forms on ACCESS so the usr(s) will be able to enter data quickly.


Jenny Jacobson
[e-mail]
=========================================================================
Date:         Tue, 7 Dec 1993 16:56:19 +1000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Kelvin Baggs <[e-mail]>
Subject:      Re: How do I save reports to an ASCII file?
In-Reply-To:  <"bunyip.cc.uq:125490:931207064214"@cc.uq.oz.au> from "Jenny
              Jacobson" at Dec 7, 93 00:36:22 am

>
> Thanks to all who wrote to me personnaly and offered their ideas.
> I've solved the problem for our situation.  A posting on WordPerfect
> discussion grouop gave me a clue to follow.  Here's what I do:
>
> 1) export the table(s) in ASCII-delimited format.
> 2) Use Word Perfect to convert the file to a Merge-Data file.
> 3) Create Merge Forms to process the records in Word Perfect.
> 4) Sort the Merge-Data file(s) so my output will be in sorted order.
> 5) Print the report(s).
>
> I'm using WordPerfect 6.0 for Windows.  Next, I'm going to design input
> forms on ACCESS so the usr(s) will be able to enter data quickly.
>
>
> Jenny Jacobson
> [e-mail]
>
I have experimented with MS ACCESS and MS WORD, and they work together
wonderfully if you require a mail merge facility.  I am using MS ACCESS 1.1
and MS WORD 6.0.


--
+-------------------------------------------------------------+
| Kelvin                                                      |
+-------------------------------------------------------------+
=========================================================================
Date:         Tue, 7 Dec 1993 09:32:09 CET
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Hilger Martin Dr." <[e-mail]>
Subject:      Microsoft, Access 2.0

Hi!

What I don't understand is why it shouldn't be possible to let the "public"
on the Access-lists know a bit about the feature-set of Access 2.0. About
AccessBasic, the macro language, its engine and if the engine will be
incorporated in Visual Basic. If it is VBA-compatible and which is the
major direction.

I clearly can see no reason to keep that under cover as all the guys from
Borland, Novell and others surely have better sources than we could ever
have. I think nothing would be easier for the other vendors than to see an
alpha or a beta-copy of anew product.

Another thing...

BTW is there any way to put a "Change Password"-command into an
Access-application when I'm using the runtime-module? Anyway I don't want
to have to display the database-container or a similar thing. It seems to
me that this is a major disadvantage of using Access that users cannot be
forced to have a password or to change it when using the runtime module.

Are there any third-party analysis tools on the market that would enable me
to find all tables, queries belonging to a certain report? Find all
locations of any object. Now I find it very hard to decide if an object can
be deleted because I may have to check through tons of tables, queries,
forms and so on to find out or I have to put everything I do into the
documentation.

Regards

Martin
=========================================================================
Date:         Mon, 6 Dec 1993 22:48:25 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Todd Merriman <[e-mail]>
Subject:      Re: help with oracle connections

>I would appreciate some information from people who have worked with both
>oracle and access.

I have developed with both, but not on the same project!

Oracle is a second-to-none industrial-strength database product.
Oracle has PC development tools, but they are an extreme hog
on the PC platform.  However, they give superior control over
distributed databases by allowing tables that physically exist
on remote hosts to appear local to the PC.  The network transport
is invisible to the application.

If you don't need a full ANSI-compliant SQL or things like stored-
procedures, triggers and a high granularity of security, then I
don't see why the PC application could not be developed under
Access.   The Oracle PC tools cannot provide the elegant interface
that Access can provide.

>I am planning to use access on a pc as a front-end
>and oracle as the main database which is on a sun station.

If you require other distributed applications on the server then
this will be an ideal configuration.  If the server is Unix,
you get mail, uucp, remote logins; and the system is much easier
to backup than any dedicated MSDOS network server.

| Todd Merriman - Software Toolz, Inc. [phone]  / Maintainer of the
| 8030 Pooles Mill Dr., Ball Ground, GA 30107         / Software Entrepreneur's
| [e-mail]                              / Mailing List

Simple systems are not feasible because they require infinite testing.
=========================================================================
Date:         Tue, 7 Dec 1993 11:12:33 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Brian Henning <[e-mail]>
Subject:      Control Menu Problem
In-Reply-To:  <[e-mail]>

Hi,

Has anyone experienced this problem?  I have called the MS Access hotline
and they were polite but of no help.  Event on form A hides form A and
opens form B.  On Close event of B changes visible property of form A back
to true. Everything works fine but I end up with two control menus (the
little gray box on the left of the window with the dash in it.) If I
repeat the step I get yet another control menu!

I'm running 1.1.  Both forms are have the Popup and Modal properties set
to No.  If I close B and restore A with the Window Show command it still
happens so I don't think the problem is so related to B.  I don't really
want to close A and then re-open it since It takes too long and I lose
the context of the current record.  I've been through the knowledge base and
have not found anything.

Appreciate any help.

Brian Henning
On contract
at Pacific Bell
=========================================================================
Date:         Tue, 7 Dec 1993 11:38:06 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Mark=[e-mail]
Subject:      Re: Control Menu Problem

Brian Henning <[e-mail]> Wrote:
|
|
| Hi,
|
| Has anyone experienced this problem?  I have called the MS
| Access hotline
| and they were polite but of no help.  Event on form A hides
| form A and
| opens form B.  On Close event of B changes visible property
| of form A back
| to true. Everything works fine but I end up with two control
| menus (the
| little gray box on the left of the window with the dash in
| it.) If I
| repeat the step I get yet another control menu!
|
| I'm running 1.1.  Both forms are have the Popup and Modal
| properties set
| to No.  If I close B and restore A with the Window Show
| command it still
| happens so I don't think the problem is so related to B.  I
| don't really
| want to close A and then re-open it since It takes too long
| and I lose
| the context of the current record.  I've been through the
| knowledge base and
| have not found anything.

Brian,

I suggest that you may have one of those harmless Windows viruses that
plays tricks on you.  I had one played on me (April 1) that had me chasing
buttons around.

Nontheless, I replicated what you described and everthing worked fine for
me.

Hope this helped.
Mark Wignall
=========================================================================
Date:         Tue, 7 Dec 1993 18:33:59 -500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Harry J. Weeds" <[e-mail]>
Subject:      Re: W(h)ither Access 2.0

Seems to me like a sly, if unofficial confirmation from Microsoft.
=========================================================================
Date:         Wed, 8 Dec 1993 08:20:35 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Todd Alley <[e-mail]>
Subject:      System Wide Changes

ACCESS Global Changes!

This may be a FAQ, however, I am trying to find an easy way to change the
fonts used in all my forms/controls.  The only way I've found is to modify
each control in each form individually.  Seems like there should be a global
method for making system wide changes..



Todd Alley
Coleman Research
407-352-3700
=========================================================================
Date:         Wed, 8 Dec 1993 08:51:45 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Steve Bratten <[e-mail]>
Subject:      System wide changes...

>This may be a FAQ, however, I am trying to find an easy way to change the
>fonts used in all my forms/controls.  The only way I've found is to modify
>each control in each form individually.  Seems like there should be a global
>method for making system wide changes..
>Todd Alley

Todd,

I don't know any method to change fonts system wide. However, if you
have the tool bar visible (select OPTIONS from the VIEW menu,) you
can use it to change the font and point size of a selected group of
controls; attributes selected from the Palette will also affect each
control in a selected group, as will various menu selections from the
LAYOUT menu.

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|                         o__                                          |
| Steve Bratten          _.>/^_      BITNET < GE0793@SIUCVMB >         |
| Graduate School       (_) \(_)   INTERNET < [e-mail] > |
| Southern Illinois University                                         |
| Carbondale IL 62901-4716   \o  \o  \o   Graduate School              |
| Voice: [phone]       |>  |>  |>  Southern Illinois University |
|   Fax: [phone]      < \ < \ < \  Carbondale, IL  62901-4716   |
|                                                                      |
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^Steve Bratten^^^^^^^^^
=========================================================================
Date:         Wed, 8 Dec 1993 07:52:17 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Thornton Prime <"Thorton_~Prime_at_lmu-acad1"@LMUMAIL.LMU.EDU>
Subject:      Re: Control Menu Problem

> Has anyone experienced this problem?  I have called the MS Access hotline
> and they were polite but of no help.  Event on form A hides form A and
> opens form B.  On Close event of B changes visible property of form A back
> to true. Everything works fine but I end up with two control menus (the
> little gray box on the left of the window with the dash in it.) If I
> repeat the step I get yet another control menu!

My database application does something almost identical to the situation you
described above with no problem whatsoever.  It sounds like some mysterious
conflict with some other software (are any other tasks running?)
=========================================================================
Date:         Wed, 8 Dec 1993 11:15:54 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      FAQ compilation--call for volunteers

Herewith a call for a volunteer(s) to compile a FAQ (of Access-related
questions, not "how do I unsub?" type questions) that can be sent out
along with the quarterly administrative post and kept in the list
archives.  I don't have time to do this myself but surely someone out
there can cull through the list archives and find the frequently-asked
stuff...

Thanks!

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Wed, 8 Dec 1993 08:54:02 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         MontyK <[e-mail]>
Subject:      Many Thnx for Response to: W(h)ither Access2.0

   i very much appreciate the many responses to my request for any
info on the whereabouts of Access2.0 .  i sincerely hope no one gets in
any difficulty over their responses.
   the rest of my remarks are directed to those professional listeners on
this sub-list affiliated with MS:
   Access is one hell of a product, despite some limitations!! But management
here is considering dropping it and using just VB instead of using both. i
think that's a bad mistake and tht we shld retain Access among our standard
suite of software.
   So, the upshot of all this, dear MS listeners, is tht my inquiry and all
the reponses substantiating the status on Access2.0 were very much in MS'
interest to my way of thinking............Regards
=========================================================================
Date:         Wed, 8 Dec 1993 17:22:42 GMT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "M.G.Dastagir" <[e-mail]>
Subject:      Re: FAQ compilation--call for volunteers
In-Reply-To:  <no.id>; from "Nathan Brindle" at Dec 8, 93 11:15 am

>
>
> Herewith a call for a volunteer(s) to compile a FAQ (of Access-related
> questions, not "how do I unsub?" type questions) that can be sent out
> along with the quarterly administrative post and kept in the list
> archives.  I don't have time to do this myself but surely someone out
> there can cull through the list archives and find the frequently-asked
> stuff...
>
> Thanks!
>
> -----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
> Nathan C. Brindle, Administrative Specialist, Student Activities Office
> Indiana University Purdue University Indianapolis
> Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
> List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
> Internet:    [e-mail]
> Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
> ------------------------------------------------------------------------------
>

I'm interested in working as a volunteer. Please contact.

Dastagir
<[e-mail]>
=========================================================================
Date:         Wed, 8 Dec 1993 13:18:10 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Re: W(h)ither Access 2.0

%From: "Harry J. Weeds" <[e-mail]>
%Seems to me like a sly, if unofficial confirmation from Microsoft.

No, I'd take it as a serious warning (or worse).

In some markets the competition stress is staggering.

Microsoft and Borland take leaking preannouncement information
very seriously.  And a violation wouldn't just blacklist the
offending party, it would probably blacklist their firm.  Pretty
strong motivation -- how would you like to be responsible for
interfering with your firm's competitive advantage just because
they were no longer welcome to participate in a Beta program?

Microsoft and Borland provide mechanisms for the discussion and support
of official Beta programs, whatever those might or might not be.  Whilst
that would seem to be mostly for technical support, I believe they
serve a secondary (but often just as important) role:  allowing
people to discuss forthcoming products such that they are a little
more commonplace and people aren't sitting on a secret so terrible
that they feel like they'll burst and can't resist blabbing.

Right now, the competition to get onto Beta programs (both current
and forthcoming) is so strong one must be willing to abide by the
rules of the program.  Regardless of how one feels about the
stringent requirements, no one is forcing anyone else to
participate.  One of the non-negotiable rules, however, is disclosure
of information about the product in the Beta cycle.  I believe
there might even be fine print about discussing the Beta after
the product is released (perhaps not these two vendors, but I have
dealt with early releases in this fashion) simply because people have
a tendency to misunderstand minour errors.  Have you looked in a
Compu$erve forum after a product release?  Half the messages have
a subject line of "X is buggy." Looking inside the messages will
then reveal screens & screens of diatribe, many of which are
nothing more than customizable options the user has failed to read
either the documentation for or the help file.  Every product has
loose ends, but in this day & age, few are disasters because so
much market share depends upon solid, reliable software.

food for thought.

I'll climb off of my soapbox (for now).
=========================================================================
Date:         Wed, 8 Dec 1993 10:31:17 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Corey Lawson <[e-mail]>
Subject:      How to change the database objects window...

How do you get the size of the database objects window to be saved with
the database, instead of having to resize it everytime I open the DB?  I have
some long object names (forms, queries, etc.) where the key info is at the
end of the name...probably bad naming, I know, but...

Thanks...

-Corey Lawson
[e-mail]
        or
[e-mail]
=========================================================================
Date:         Wed, 8 Dec 1993 13:40:34 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Many Thnx for Response to: W(h)ither Access2.0

%    the rest of my remarks are directed to those professional listeners on
% this sub-list affiliated with MS:
%    Access is one hell of a product, despite some limitations!! But management
% here is considering dropping it and using just VB instead of using both. i
% think that's a bad mistake and tht we shld retain Access among our standard
% suite of software.

I would seriously consider making a case for retaining both products.
Separately, they are great.  Together they are great.  It provides
you with three options:  1) VB; 2) Access; 3) VB + Access

(keep as many options open as long as possible)

cheers.
=========================================================================
Date:         Wed, 8 Dec 1993 11:38:47 PST
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Re: Many Thnx for Response to: W(h)ither Access2.0
In-Reply-To:  <[e-mail]>; from "Phil Paxton" at Dec
              8, 93 1:40 pm

> %    the rest of my remarks are directed to those professional listeners on
> % this sub-list affiliated with MS:
> %    Access is one hell of a product, despite some limitations!! But managemen
t
> % here is considering dropping it and using just VB instead of using both. i
> % think that's a bad mistake and tht we shld retain Access among our standard
> % suite of software.
>
> I would seriously consider making a case for retaining both products.
> Separately, they are great.  Together they are great.  It provides
> you with three options:  1) VB; 2) Access; 3) VB + Access
>
> (keep as many options open as long as possible)
>

You've left out one of the selling points of Access...

4) Access + anything else

--
TONY HAMILTON ==================================================
 Intel Corporation            | voice: 916-356-3070
  Folsom Engineering Services | mailstop: FM2-17
   PC Applications            | email: [e-mail]
================================================================
=========================================================================
Date:         Wed, 8 Dec 1993 14:36:52 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: Many Thnx for Response to: W(h)ither Access2.0
In-Reply-To:  Message of Wed,
              8 Dec 1993 13:40:34 EST from <72410.2162@COMPUSERV E.COM>

I agree with Phil.  Owning both is sometimes a lifesaver.  I have the
ability to write Access-like interfaces to be used with Access databases
and <distribute> them to people who don't have Access.  And I didn't
have to shell out for the ADK...:)

Seriously, there are some things missing in VB that would really be nice
to have--such as data-aware list and combo boxes (you should see the dodge
I wrote to fake a data-aware combo box!)--shucks, just more data-aware
controls all the way around...the common dialog control should have Find
and Replace dialogs added to it...ya know.

I'm writing an app in VB right now that's just plain EXHAUSTING...dumb
little things like the toolbox disappearing behind things as soon as it
doesn't have the focus, unlike in Access where it stays in front.  Even
though I cuss that from time to time, it's often handy to have the tool
box and the properties box stay in front all the time...or at least to
have the OPTION to let them do so...but in most respects, I like the
product and am durn glad I bought the pro version rather than the standard
version.

Now if the VB/DOS developers would create a data control for Access MDBs
so we could access our data from DOS....:)....I'd be in heaven....

Nathan

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Wed, 8 Dec 1993 11:50:11 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Mark=[e-mail]
Subject:      Re: Many Thnx for Response to: W(h)ither Access2.0

Nathan Brindle <[e-mail]> Wrote:
| Seriously, there are some things missing in VB that would
| really be nice
| to have--such as data-aware list and combo boxes (you should
| see the dodge
| I wrote to fake a data-aware combo box!)--shucks, just more
| data-aware
| controls all the way around...the common dialog control
| should have Find
| and Replace dialogs added to it...ya know.

Nathan,

Check out the new controls available from Cresent Software ... It's got
the data-ware combo's plus more ...

*I am in no way affiliated with Cresent software, just a happy end-user *
=========================================================================
Date:         Wed, 8 Dec 1993 16:18:31 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: Many Thnx for Response to: W(h)ither Access2.0
In-Reply-To:  Message of Wed,
              8 Dec 1993 11:50:11 PST from <Mark=Wignall%MfgEng%
              [e-mail]>

Oh, this was too easy to want to bother with another add-in VBX...I created
a drop-down combo box with some default choices in it and created a text
box bound to the appropriate database field right on top of it...then I
used the Click event to feed the choice from the combo box into the text
box...I was rather proud of myself.  :)

The hard part was figuring out that it would work in the first place...oy,
my aching head.  :))  (I am not the greatest intuitive programmer in the
world, as you might have already guessed...)

In any case...back to Access...(bad listowner!  bad!:)

Nathan

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Wed, 8 Dec 1993 19:01:28 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Access2.0 + VB/DOS | Was:  blah-blah-blah

% Now if the VB/DOS developers would create a data control for Access MDBs
% so we could access our data from DOS....:)....I'd be in heaven....

Cringely's column in InfoWorld several months ago spouted the rumour
that VB/DOS won't be revised any more.
=========================================================================
Date:         Wed, 8 Dec 1993 19:06:30 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Non-Disclosure

Thanks, Phil for your calming comments concerning non disclosure... They
were right on target and I'm sure John Betz (the Microsoft jock)
especially appreciated it.

% ...but I didn't detect any trade secret leak
% from that comment.

I believe it had to do with the potential existence of a product.
Microsoft usually won't even acknowledge something is in progress
beyond "the next release" if even that until it has been announced.

% Don't stop contributing to this list.... many of us do appreciate it.

Thanks. I wish I had more time to contribute to the problem-solving,
especially after the things I've worked on so far.  Unfortunately,
my load right now involves about fifteen or so books in progress
*and* reading about fifty magazines cover-to-cover (others prefer
to skim, but I can't resist the compulsion) *and* following a
bazillion Compu$erve forums *and* monitoring Internet *and*...well,
you get the picture.
=========================================================================
Date:         Thu, 9 Dec 1993 09:51:00 +1000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Kevin Anderson <[e-mail]>
Subject:      Re: W(h)ither Access 2.0

I fully support and agree with all that you have said.

Kevin
=========================================================================
Date:         Thu, 9 Dec 1993 11:22:57 +1030
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         yapja <[e-mail]>
Subject:      Duplicates

Sorry for not paying attention before but......

I have a small problem that I am sure has been solved on this list before,.

I have two tables. Table A has some duplicate records (multiple occurences
of keyA). Table B also has duplicate records (multiple occurences of keyB).

Problem: I want to join the two tables and perform some calculations but I
only want the first occurence of keyA not all occurences. Example,

Table A                                                    Table B
KeyA                                                         KeyB
1a                                                               1a
 Select
1b                                                                            Do
 not select
                                                                   1b
 Select (with 1adata
etc.

Any ideas ????


Thanks ..... in advance
=========================================================================
Date:         Wed, 8 Dec 1993 19:56:05 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         George Raudabaugh <[e-mail]>
Subject:      Re: Non-Disclosure

After seeing these discusions and seeing we have Microsoft folks on the
list I would like to throw out the following (and then be blacklisted
for the rest of my life, but see below):

a.  The ODBC 2.0 conference was the same week as the ANSI X3H2 (i.e. SQL)
    meeting.  I received an ODBC 2.0 questionaire but was informed that we
    weren't going to be part of the beta (one of my jr. developers went to
    the conference but I was rather po'd given the timing and response).

b.  The 32-bit developer conference is next week, guess what, another X3H2
    meeting (there are only 5 of these things each year, and Microsoft should
    know the dates).  Same thing on the Beta except this was done via email
    and I didn't get a response.

As a driver developer I'm trying to do the best with what I have.  In as much
as our company is an integrator, I'm POd that MS left us out of the beta of
access, but what the hell, there is always Powerbuilder, Gupta, etc.

GR
--
George Raudabaugh               Manager/Document Technologies
Information Dimensions, Inc.    [e-mail]            (work email)
5080 Tuttle Crossing Blvd.
Dublin, Ohio  43017             [phone]                     (voice mail)
=========================================================================
Date:         Wed, 8 Dec 1993 19:15:01 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Bill Stewart <[e-mail]>
Subject:      Re: Many Thnx for Response to: W(h)ither Access2.0

You might let management know that Access and Visual Basic are solid
compliments to one another.   I am working on some projects that require
the use of not only Access, but VB to help in streamlining the end
application.

I really have high admiration for MicroSoft in developing two very powerful
development tools that compliment each other so well.

[e-mail]
Bill Stewart
Glendale Community College
=========================================================================
Date:         Wed, 8 Dec 1993 19:17:05 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Bill Stewart <[e-mail]>
Subject:      Re: How to change the database objects window...

Unfortunately you can't.  You're stuck with the default size.

[e-mail]
Bill Stewart
Glendale Community College
=========================================================================
Date:         Thu, 9 Dec 1993 08:23:47 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "John A. Olson" <[e-mail]>
Subject:      Re: Duplicates

>Sorry for not paying attention before but......
>
>I have a small problem that I am sure has been solved on this list before,.
>
>I have two tables. Table A has some duplicate records (multiple occurences
>of keyA). Table B also has duplicate records (multiple occurences of keyB).
>
>Problem: I want to join the two tables and perform some calculations but I
>only want the first occurence of keyA not all occurences. Example,
>
>Table A                                                    Table B
>KeyA                                                         KeyB
>1a                                                               1a
> Select
>1b
  Do
> not select
>                                                                   1b
> Select (with 1adata
>etc.
>
>Any ideas ????
>
>
>Thanks ..... in advance
>
>

I believe that if you design your query in such a way as to group the data
in table A on each field, and then choose First rather than Group on your
key field(s) you can achieve what you are hoping for.  The little summation
sign at the top will allow you to group information.  I'm sorry if this is
not too clear but I'm short on time today.

Good luck!

John
=========================================================================
Date:         Thu, 9 Dec 1993 09:37:35 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Scott F Eggert <[e-mail]>
Subject:      forms

hi,
is there anyone out there that knows if there is a good book or something on
how to make nice looking forms?  I heard that Microsoft puts out something
about their standard form designs, but I havn't seen it.

thanks
[e-mail]
=========================================================================
Date:         Thu, 9 Dec 1993 09:47:08 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Henry Stock <[e-mail]>
Organization: BMGT/SPA
Subject:      Re: Another Form of Duplicates (Non ACCESS...)

I seem to be getting duplicate copies of every message on this
LISTSERV.  Although I enjoy reading the messages that pass through
here, I don't enjoy them that much.

Could someone please explain how that happens and hopefully help
me cut out the duplicates?
Henry J. Stock Jr.
Campus Computing Associate
College of Business Management
/ School of Public Affairs

Room 2413D, Van Munching Hall
University of Maryland
College Park, MD 20742-1815
Fax: (301) 405 - 2276
Phone: (301) 405 - 2141
Internet Address: [e-mail]
=========================================================================
Date:         Wed, 8 Dec 1993 20:08:28 -500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Harry J. Weeds" <[e-mail]>
Subject:      Re: W(h)ither Access 2.0
In-Reply-To:  <[e-mail]>

Seems to me like a sly, if unofficial confirmation of the product from MS.
=========================================================================
Date:         Thu, 9 Dec 1993 12:55:30 -0800
Reply-To:     Brian Henning <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Brian Henning <[e-mail]>
Subject:      Re: MS Access - Double Control Boxes
In-Reply-To:  <[e-mail]>

On Thu, 9 Dec 1993, Ian Hope wrote:

> Brian,
>
> I have had the double control boxes happen to an application I
> am developing. The problem I get seems to happen irregularly
> (in my case). I am using hidden forms, opening dialogue boxes
> and custom menu's for forms. When the problem occurs in my particular
> case, when clicking on the menu line I get an error saying cannot
> find the macro for that menu item. Also I get two control boxes
> in the left.

Thanks Ian. At least I know I'm not crazy. The situation, including menu
problems is the same exact problem as mine.

I have since come up with a work-around. Instead of having form B hide
form A from B's "on-open" event, I have A code hide A first and then Open
B. I have to suppress screen output because there is no screen for a moment
(I didn't have to do that before). It now works fine.

Thanks to all.

Brian Henning
=========================================================================
Date:         Thu, 9 Dec 1993 14:51:58 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jim Renaud <[e-mail]>
Subject:      Re: W(h)ither Access 2.0

I guess it is a moot point right now since Microsoft publicly announced today
Access 2.0 at its DevCast #3. The sneak preview showed Access 2.0 to support VBA
,
more advanced Wizards, and referential integrity support built into its engine
[that means the engine will automatically delete records if a related record was
going to be deleted. This saves alot of manual programming.]

There are probably other features, these are the ones I remembered.



-----------------------------------------------------------------------

Jim Renaud                              [Standard Disclaimer]

Amdahl Corporation
M/S 205                                 Phone:  [phone]
Bldg. M3  Room 235                      Fax:    [phone]
1230 E. Arques Avenue                   Email:  [e-mail]
Sunnyvale, CA 94088-3470
=========================================================================
Date:         Thu, 9 Dec 1993 17:04:03 CST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Converted from PROFS to RFC822 format by PUMP V2.2X
From:         Stace Cameron <[e-mail]>
Subject:      Access as Front end to MS SQL Server Error

         Thanks to an article in the knowledge database (Q88173),
         I have solved the problem for which I requested your
         help.  Following is my original post and the steps I
         left out.  (See 3.1 and 3.2) Thanks for the help.

>>I have to admit I am a complete novice when it comes to Microsoft Access.
>>I am attempting to use Access to view the sample PUBS database that resides
>>on our recenlty acquired MS SQL Servrer. Following are the steps I have
>>tried and the resulting error message. I would appreciate pointers as to
>>where I am going wrong. Thanks.
>>
>>1. Access is installed on the network.
>>2. Ran setup /n to install Access on my workstation.
>>3. Ran Microsoft ODBC setup to install SQL SERVER ODBC DRIVER

  3.1  Run the INSTCAT.SQL script to install the catalog stored procedures
  3.2  Run the RECONFIGURE command against the master database using SAF

>>4. Start up Access
>>5. Select New Database called it PUBS in my c:\ACCESS directory
>>6. Picked Attach Table
>>7. Picked <SQL Database> as the Data Source
>>8. Picked the ODBC driver as the SQL Data Source
>>9. Logged in the SQL Server as SA
>>10. The list of tables in the remote database is displayed
>>11. Pick the first one and click Attach and then get:
>>
>>Reservered Error (-7745): There is no message for this error.

Stace Cameron                           BITNET: GH0234@SPRINGB
Director                              INTERNET: [e-mail]
Office of Administrative Computing
Southern Illinois University School of Medicine    Phone: [phone]
PO Box 19230, Springfield IL 62794-9230              FAX: [phone]
=========================================================================
Date:         Thu, 9 Dec 1993 15:25:11 PST
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Re: W(h)ither Access 2.0
In-Reply-To:  <[e-mail]>; from "Jim Renaud" at Dec 9,
              93 2:51 pm

> I guess it is a moot point right now since Microsoft publicly announced today
> Access 2.0 at its DevCast #3. The sneak preview showed Access 2.0 to support V
BA
> ,
> more advanced Wizards, and referential integrity support built into its engine
> [that means the engine will automatically delete records if a related record w
as
> going to be deleted. This saves alot of manual programming.]
>
> There are probably other features, these are the ones I remembered.

Any announced release dates? I'm sure I'm not the only one who is in a
situation where the timing of Access 2.0 release may determine whether I
wait for it or go with something else, despite having already developed
with v1.1 ...

--
TONY HAMILTON ==================================================
 Intel Corporation            | voice: 916-356-3070
  Folsom Engineering Services | mailstop: FM2-17
   PC Applications            | email: [e-mail]
================================================================
=========================================================================
Date:         Fri, 10 Dec 1993 13:31:00 +1000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Kevin Anderson <[e-mail]>
Subject:      Re: W(h)ither Access 2.0

Access 2.0 was announced at its DevCast #3 (I have no idea
what this stands for??), but any dates on its release
either in USA or overseas (AUSTRALIA)???

Any help from the Microsoft staff watching, now that is official,
would be greatly appreciated..

Kevin Anderson
=========================================================================
Date:         Thu, 9 Dec 1993 19:59:00 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Kapczynski, Mark" <[e-mail]>
Subject:      UPDATING FILEDS

I'm trying to update fields from one access table into another access table
with a matching field.  The problem that I have is that if I do this via a
joined query, the dynaset of records is locked and uneditable.  So--how can
I update like fields in 2 access tables and still be able to edit the
records.

Thanks for any help--Mark
=========================================================================
Date:         Thu, 9 Dec 1993 16:02:02 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John Betz <[e-mail]>
Subject:      Access Technology Preview

Jim-

I am pleased you were able to view today's presentation of DevCast #3.
I just want to take this opportunity to set the record straight on what
was shown regarding Access.

We simply presented a bit of the work in progress for the next version
of Microsoft Access. This was not  a product announcement by any means,
we just wanted to share some of the things we are working on. I am
happy to hear you liked what you saw!

Specifically, we showed work  in the following areas of interest to developers:

* More properties able to be set at runtime.
* OLE 2.0 features including OLE Automation and Visual Editing
* Button Wizard
* Referential Integrity Enhancements - Cascading Updates and Deletes

Thanks much,

John Betz
Access Product Manager




----------
From: Jim Renaud  <netmail![e-mail]>
To: Multiple recipients of list ACCESS-L
<netmail!ACCESS-L![e-mail]>
Subject: Re: W(h)ither Access 2.0
Date: Thursday, December 09, 1993 2:51PM

I guess it is a moot point right now since Microsoft publicly announced today
Access 2.0 at its DevCast #3. The sneak preview showed Access 2.0 to
support VBA
,
more advanced Wizards, and referential integrity support built into its engine
[that means the engine will automatically delete records if a related
record was
going to be deleted. This saves alot of manual programming.]

There are probably other features, these are the ones I remembered.



-----------------------------------------------------------------------

Jim Renaud                              [Standard Disclaimer]

Amdahl Corporation
M/S 205                                 Phone:  [phone]
Bldg. M3  Room 235                      Fax:    [phone]
1230 E. Arques Avenue                   Email:  [e-mail]
Sunnyvale, CA 94088-3470
=========================================================================
Date:         Fri, 10 Dec 1993 07:15:50 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Morris Myers <[e-mail]>
Subject:      Re: Access Technology Preview

> This was not  a product announcement by any means,
> we just wanted to share some of the things we are working on. I am
> happy to hear you liked what you saw!
>
> ...
>
> John Betz
> Access Product Manager
>
I think we are dealing more with semantics here than with reality. The
reality is that you presented functions that will be included in Access
2.0 (at least that is your current intent). Things can change and might, in
that you may add more functions and you might remove some of the functionality
that you demonstrated yesterday. I think we all understand how that works. As
far as whether yesterday's demonstration was an anouncement or not -- does it
change the fact that you acknowledged there was a 2.0 release of Access?

I like the product, I look forward to the next release (whatever version
number you assign it). I was pleased with the demonstrated capability. I
don't particularly care for the word games of announcement or non-announcement.
In fact, I think it detracts from the positive iamge you presented yesterday.

Just one man's opinion ...

g.mo


__

-----------------------------------------------------------------------

Morris Myers                            [Standard Disclaimer]

Amdahl Corporation
M/S 205                                 Phone:  [phone]
Bldg. M3  Room 311                      Fax:    [phone]
1230 E. Arques Avenue                   Email:  [e-mail]
Sunnyvale, CA 94088-3470                or:   [e-mail]
=========================================================================
Date:         Fri, 10 Dec 1993 10:34:33 EST
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Resent-From: Nathan Brindle <NBRINDLE@INDYCMS>
Comments:     Originally-From: BITNET list server at INDYCMS (1.7f)
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Subject:      Forms (was: ACCESS-L: error report from VRINET.COM)

Sigh...OK, guys and gals, let me repeat one more time...when you reply
to the list with included text, PLEASE remember to remove header lines
from the body of your forwarded message.  If you don't, I just get the
message dumped to me as an error.  Not all mail packages have this
problem, but the lines aren't needed anyway, so why not delete them?
(You can also "comment" them out by placing a > character directly in
front of the offending header line...see below...but it would make for
less hassle on the part of the rest of us if they were just DELETED.)

Also sprach LISTSERV@INDYCMS:

The  enclosed mail  file, found  in the  ACCESS-L reader  and shown  under the
spoolid 6147  in the console log,  has been identified as  a possible delivery
error notice for the following reason: "Sender:", "From:" or "Reply-To:" field
pointing to the list has been found in mail body.

>From: Dave Finley <[e-mail]>
>Message-Id: <[e-mail]>
>Subject: forms

hi,
is there anyone out there that knows if there is a good book or something on
how to make nice looking forms?  I heard that Microsoft puts out something
about their standard form designs, but I havn't seen it.

thanks
[e-mail]


Scott and all on Access-L:

The book you're probably thinking about is "The Windows Interface: An
Application Design Guide", by Microsoft Press. The ISBN # is:
1-55615-439-9. List Price is USA $39.95.

It provides suggested standards for forms, menus, controls, etc. It should
be in the library of ANY MS-Window developer, and provides useful standards
for any Windows programming shop.


Dave Finley
[e-mail]

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Sat, 11 Dec 1993 09:33:56 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Malaspina News Gateway <[e-mail]>
Subject:      file dialog box from a module?

From: [e-mail] (Ron Apland)

I am creating a database that requires regular importing from two fixed field
text files.  I would like to automate the process but have run into problems.
I have tried the transfer_text function in the macro section but it requires
the file to always be in the same place and have the same name.  I have also
tried a sendkeys combination but Import only appears on the database menu
and once I focus the database window the macro halts and the rest of the
keystrokes do not execute.

I would like to have a file requestor box open so that I could find the file
first.  I have looked for a way of doing this from ACCESS BASIC and have the
file path/name read into a variable to be used with the transfer_text function
but have been unsuccessful.  Another possibility is to execute the whole
process from a module in ACCESS BASIC but alas I don't know how to do this
either. (I don't have VB3)

Any help with this problem would be appreciated.

Ron

--------------------------------------------------------------------------------
Received: by mala.bc.ca (MX V3.3 VAX) id 19873; Sat, 11 Dec 1993 09:13:45 PST
To: [e-mail]
=========================================================================
Date:         Sat, 11 Dec 1993 18:36:15 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: file dialog box from a module?
In-Reply-To:  <[e-mail]> from "Malaspina News Gateway"
              at Dec 11, 93 09:33:56 am

Ron,

There is a good example of how to do this in an article by Paul Litwin
in the December of Smart Access.  It is a demonstration of how to
reattach files on the fly, but it uses the Windows common dialogs to do
it.  If you don't have access to the publication, call Pinnacle
Publishing at 800-788-1900 or 206-251-1900.

John
[e-mail]
=========================================================================
Date:         Sat, 11 Dec 1993 18:39:35 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: UPDATING FILEDS
In-Reply-To:  <[e-mail]> from "Kapczynski,
              Mark" at Dec 9, 93 07:59:00 pm

Mark,

Use an update or an append query, depending on your needs.  You can run
them from Access BASIC using the Execute method.

John
[e-mail]
=========================================================================
Date:         Sat, 11 Dec 1993 18:41:23 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Access Technology Preview
In-Reply-To:  <[e-mail]> from "John Betz" at Dec 9,
              93 04:02:02 pm

John,

Is nice to see that MSFT is going to start monitoring traffic here a bit
more closely!

John
[e-mail]
Woodinville, WA
=========================================================================
Date:         Sat, 11 Dec 1993 21:47:36 CST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Richard Moldwin <[e-mail]>
Subject:      Access on OS/2 or NT

Hello out there!
        Has anyone on this list tried to run Access on OS/2 or NT?  How does
it run?  By the way, I've recently switched from a 50 MHz 8MB non-VESA-LB to
a 66MHz, 16MB VESA-LB Gateway, and Access runs about twice as fast on the
newer system.  If you are looking for speed improvements, this is the way to
go!
Over & Out
-Rich Moldwin
=========================================================================
Date:         Sun, 12 Dec 1993 10:18:12 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         richard dixon <[e-mail]>
Subject:      Modules or Macros with Access and VB?

Quite a few months ago someone mentioned that when writing an Access app
to be used in conjunction with VB that it was preferable to use Modules
in Access instead of Macros.  Could someone elaborate?  I am still
learning and thus I don't see the logic.  Some help here could save me
down the road.

Thanks everyone,
Richard
=========================================================================
Date:         Mon, 13 Dec 1993 09:19:16 MET
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         DeJean <[e-mail]>
Subject:      Multiple entries, conditions, ...

Hi all,

I have a table which regularelly needs an input like this:

Field1  Field2  Field3  Field4  Field5  Field6
Item1   Item2   Item3   Item4   Item5   Item6
Item1   Item2   Item3   Item7   Item8   Item9
Item1   Item2   Item3   Item10  Item11  Item12
Item13  Item14  Item15  Item16  Item17  Item18
Item13  Item14  Item15  Item19  Item20  Item21

The input is done via a form. Instead of having to enter the constant Fields
again for every new record, I would like to do the following. First ask for
the constant fields in single forms, then pop-up a large form which
contains the constant fields as non-editable text and a sub-form in table
format in which you can enter the variable fields.
I have done this but I encounter a problem. In the subform I have included
all fields, with the non-variable ones not visible and with the expression
=Forms![InputForm1]![Field1]. When I show the complete sub-form, he does
what he had to do, the non-variable fields are correctly filled in. But
when I look to the table, he has only filled in the variable fields.
Anybody who knows why this happens?

A second problem I have is the following:
When the forms for the input of the non-variable field show up
sequentially, I want to check for one field, if it is included in table2.
The only way I found to do this is making a query:

        Field2                                          Field2
                                                                Count
        =Forms![InputForm2]![Field2]

If the Item2 is already in the table, the CountOfField2 is 1. The problem
is that if it is not in the table, it contains no value.
In my accompanying macro I have put a condition:

Step1   Forms![CountOfField2]![CountOfField2] = 1       RunMacro

And this condition doesn't interpret the no-value correctly.
Moreover, even if the condition is true, he doesn't execute the macro
(which is the same macro but with Step2). Any solution to this?

A final question is: Is there no cross posting between this listserv group
and the comp.databases.access newsgroup?

Greetings and thanks in advance,

--
DeJean.

Vrije Universiteit Brussel
Belgium
=========================================================================
Date:         Mon, 13 Dec 1993 06:40:17 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Bill Stewart <[e-mail]>
Subject:      Re: Access Technology Preview

Any plans or ideas about when a Macintosh version of Access will be
available.  My campus is excited about Access, but not everyone uses a
Windows workstation.
=========================================================================
Date:         Mon, 13 Dec 1993 09:50:59 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Henry Stock <[e-mail]>
Organization: BMGT/SPA
Subject:      ACCESS and Windows NT...???

Does anyone know the secret of running ACCESS under Windows NT?

I tried to run the product under NT, but it blows up on me.  I keep
getting messages that certain DLL files were not found.  I checked
and the DLL's are there.  NT just doesn't seem to recognize or
cooperate with them.

When I set NT up I maintained my DOS and Windows on C: drive.
Windows NT is on D: drive and I choose which I want to go to on
startup.  Microsoft Word and Excel work fine.
Henry J. Stock Jr.
Campus Computing Associate
College of Business Management
/ School of Public Affairs

Room 2413D, Van Munching Hall
University of Maryland
College Park, MD 20742-1815
Fax: (301) 405 - 2276
Phone: (301) 405 - 2141
Internet Address: [e-mail]
=========================================================================
Date:         Mon, 13 Dec 1993 07:42:54 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Access Technology Preview
In-Reply-To:  <[e-mail]> from "Bill Stewart" at Dec 13,
              93 06:40:17 am

Bill,

Lots of people are interested in a Mac version of Access.  My
understanding is that there is a major technical hurdle moving to the
Mac: all of the BASIC compiler/interpreter is written in 8086 assembler.
However, Microsoft is well aware of the strong customer interest.

John
[e-mail]
=========================================================================
Date:         Mon, 13 Dec 1993 09:24:34 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         B Jonathan Schuck <[e-mail]>
Subject:      Attaching Access Tables

I'm posting for a friend.

If you split up your access into source and tables,
when you attach your Access tables, many of the properties
are *not* copied over, such as Caption, etc.

Is there any way around this?
=========================================================================
Date:         Mon, 13 Dec 1993 15:04:35 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "[e-mail]" <[e-mail]>
Subject:      Re: Attaching Access Tables

In addition, I also have the following problem:

        I have a form that is attached to one table.  I have created a
        second table which I would like the same form to use.  Is this
        possible???  Can I write data to two different tables using the
        same form???  HELP>>>>>>>>

Thanks.

Jason Beatty
Information Technology
Metropoltain State College

[e-mail]
=========================================================================
Date:         Mon, 13 Dec 1993 14:27:25 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Thornton Prime <"Thorton_~Prime_at_lmu-acad1"@LMUMAIL.LMU.EDU>
Subject:      Re: Attaching Access Tables

Jason Beatty asked:

        I have a form that is attached to one table.  I have created a
        second table which I would like the same form to use.  Is this
        possible???  Can I write data to two different tables using the
        same form???  HELP>>>>>>>>

The easiest way for you to accomplish this would be to have one table in a
subform of the other with no linking fields (no parent-child fields).  You could
also make a "dummy form", a form not attatched to any table, with two subforms
.. one for each of the tables that you want to attatch to it.

Thornton Prime
=========================================================================
Date:         Mon, 13 Dec 1993 14:35:07 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Attaching Access Tables
In-Reply-To:  <[e-mail]> from "B Jonathan Schuck" at
              Dec 13, 93 09:24:34 am

>
> I'm posting for a friend.
>
> If you split up your access into source and tables,
> when you attach your Access tables, many of the properties
> are *not* copied over, such as Caption, etc.
>
> Is there any way around this?
>

If you go into table design on the attached tables in the local mdb, and
add captions they are used by the form wizards, etc.  MSFT is aware this
is a pain for many users.

John
[e-mail]
=========================================================================
Date:         Mon, 13 Dec 1993 16:27:10 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Re: Modules or Macros with Access and VB?

>
>Quite a few months ago someone mentioned that when writing an Access app
>to be used in conjunction with VB that it was preferable to use Modules
>in Access instead of Macros.  Could someone elaborate?  I am still
>learning and thus I don't see the logic.  Some help here could save me
>down the road.
>
>Thanks everyone,
>Richard

Macros have no provision for handling run-time errors.  With Access Basic,
you can set up error handlers for a variety of conditions, and recover
gracefully.

When you encounter an error using macros, hasta la vista baby!

Bob Oberst
[e-mail]
=========================================================================
Date:         Mon, 13 Dec 1993 14:39:35 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Attaching Access Tables
In-Reply-To:  <[e-mail]> from "[e-mail]" at
              Dec 13, 93 03:04:35 pm

Jason,

If what you are trying to do is change data in two related tables, from
a single form, base the form on a query that gets the data from both
tables.  They will need to be joined by the related fields.

If what you are trying to do is dynamically change the recordsource
property for a form, I don't think that is possible.

John
[e-mail]
=========================================================================
Date:         Mon, 13 Dec 1993 19:56:55 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Kenneth Hutchinson <[e-mail]>
Subject:      Re: Attaching Access Tables

>        I have a form that is attached to one table.  I have created a
>        second table which I would like the same form to use.  Is this
>        possible???  Can I write data to two different tables using the
>        same form???  HELP>>>>>>>>

Well, if I understand your problem correctly, there are two ways to do
it, depending on the data in the tables. If the two tables share a
common field, you can build a query will the two tables and include
all the fields from both tables. Then, base the form on the query.

However, what frequently happens is that the two tables are totally
unrealted. Here, you make two separate forms, one for each table. BUT...
create one form as a subform for the other. This way, on the main form,
you have the data from the first table, then as a subform, you have the
data from the second table. If you clear the borders for the subform
object on the main form, you can get it to look like it's one big form,
completely oblivious to the end user!

Ken
[e-mail]
=========================================================================
Date:         Sun, 12 Dec 1993 19:39:00 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "James M. Blakely" <n4zfd![e-mail]>
Subject:      Re: ACCESS-L Digest - 9 Dec 1993 to 10 Dec 1993

The announcement / non-announcement semantics are a very necessary thing for
Microsoft. Why? Because they are a publicly held corporation, and there are
legal ramifications associated with "announcing" a product that is not ready
to ship, or whose shipment is not planned for any particular time frame.

This gets into the realm of the Securities & Exchange Commission's rules --
but the reasons are obvious. A company's product announcements have a
direct, real effect on that company's stock price. Prematurely announcing
product could send a stock jumping upward -- only to drop much farther when
the real product doesn't show up in a short time period.

For this reason, Microsoft, and other publicly traded companies, have a
strict policy regarding unannounced products.

On the other hand, we all know that product development is ongoing, and at
some point, an upgrade to Access will come out. Whether 2.0, 1.2, or 6.3, a
new version will come out at some point, and it will at minimum, have the
features shown in the Sneak Preview.

 --Jim Blakely, VP
Blakely-Signature Associates
A Microsoft Solution Provider
 ----------

> I like the product, I look forward to the next release (whatever version
> number you assign it). I was pleased with the demonstrated capability. I
> don't particularly care for the word games of announcement or
> non-announcement.
> In fact, I think it detracts from the positive iamge you presented
yesterday.
=========================================================================
Date:         Tue, 14 Dec 1993 08:01:17 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jon Diercks <[e-mail]>
Organization: Anderson University, Anderson, IN
Subject:      Re: semantics
In-Reply-To:  from "James M. Blakely" at Dec 12, 93 7:39 pm

> The announcement / non-announcement semantics are a very necessary thing for
> Microsoft.
...
>  --Jim Blakely, VP
> Blakely-Signature Associates
> A Microsoft Solution Provider

Speaking of semantics, isn't 'A Microsoft Solution Provider' a rather
treacherous phrasing?  Seems to imply that Microsoft is the problem!  :>

--
 \on \                     [e-mail]              Computing Services
\_\ <_\iercks                                           Anderson University
   >                                                           Anderson, IN
  ---  ...'Politically Correct' is an oxymoron. (Merry Christmas, Bill!)
=========================================================================
Date:         Tue, 14 Dec 1993 08:21:51 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Henry Stock <[e-mail]>
Organization: BMGT/SPA
Subject:      How do I get Access to work with Windows NT?

This is my second try at this message.  I didn't see my first message
in the que of messages from this listserv, so please forgive me if I
clutter your mail with duplicate messages.

A few weeks ago I loaded Windows NT on my computer.  I loaded NT
as a optional operating system so that I could choose between DOS
and NT.  I don't want to move over to NT completely until all of my
Windows applications work properly.  However, in setting NT up this
way you can not take advantage of the installation's automatic setup
of Windows applications.

I manually setup many applications, but NT would not run Microsoft
Access among other things.  When I tried to start Access I would get a
Windows error message which said that a certain DLL, actually two,
could not be found.  I checked the working directory and the DLL's
were there.  I am wondering if there is a registration mechanism that I
missed.  I think Microsoft advertises that Windows NT will run
all, (most?),  windows applications.  This is one of their own.

What gives?  Can anyone help me on this.

Thanks.
Henry J. Stock Jr.
Campus Computing Associate
College of Business Management
/ School of Public Affairs

Room 2413D, Van Munching Hall
University of Maryland
College Park, MD 20742-1815
Fax: (301) 405 - 2276
Phone: (301) 405 - 2141
Internet Address: [e-mail]
=========================================================================
Date:         Tue, 14 Dec 1993 08:40:13 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Harry Yeatts <[e-mail]>
Subject:      Passing valueS from an input box

Which goes first...the brick wall or my head?

I'm learning to program, and I'm using AccessBasic as my
vehicle. I bought a book for beginners and one of the
exercise questions has me stumped.

I'm supposed to use an input box to pass more than one value
back to a function, which then will do some calculations.

I've done the function, which works just fine. The problem is
that the input box doesn't pass back more than one value. If
the user types in, say, three values (i.e., 25,34,56), the
function receives 253456 as the single value. I did a work
around...I used three input boxes...but I think there must be
a better way.

Any hints for this novice would be greatly appreciated.

Harry Yeatts (HYEATTS)                INTERNET: VTVM1.CC.VT.EDU
Virginia Tech                         BITNET: VTVM1
Blacksburg, Virginia                  PHONE: [phone]
=========================================================================
Date:         Tue, 14 Dec 1993 07:28:57 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Passing valueS from an input box
In-Reply-To:  <[e-mail]> from "Harry Yeatts" at Dec 14,
              93 08:40:13 am

Harry,

If you wanted a user to be able to enter three values in an input box
(1,2,3) you would need to bring the values back as a string, and then
parse the string into the underlying numbers.  Commas in numbers should
only be there as a thousands seperator (US) or decimal point (Europe).

John
[e-mail]
=========================================================================
Date:         Tue, 14 Dec 1993 07:33:50 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: How do I get Access to work with Windows NT?
In-Reply-To:  <[e-mail]> from "Henry Stock" at Dec 14,
              93 08:21:51 am

Harry,

Many of the Access DLL's go in the windows\system subdirectory, not the
working subdirectory.  That may be the problem.  Also, if Access was
copied from another system, rather than installed using the installation
diskettes, there are several dll's that get left behind.

There are no problems noted in the Knowledge Base regarding NT.

Good luck.

John
[e-mail]
=========================================================================
Date:         Tue, 14 Dec 1993 08:50:48 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "[e-mail]" <[e-mail]>
Subject:      Data Base Size?

We currently have a database file about the size of 1.8MB, should I be
worried about this size?  Is there ways to cut down the size?

Also thanks for the input on (Attaching Access Tables), I am tring to
use a subform, but I can't get rid of the borders or scroll bars, does
anyone have a suggestion?

Thanks.

Jason Beatty
Metropolitan State College of Denver
Information Technology
[e-mail]
=========================================================================
Date:         Tue, 14 Dec 1993 18:34:22 EST
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Pekka Koskinen <[e-mail]>
Subject:      Re: Data Base Size?

On Tue, 14 Dec 1993 08:50:48 -0600, [e-mail] wrote:

>We currently have a database file about the size of 1.8MB, should I be
>worried about this size?  Is there ways to cut down the size?
>

Access isn't smart enough to reduce the file size automatically, if you
delete stuff etc, so you should compact the database every now and then.
This perhaps doesn't solve the problem totally, but perhaps helps a bit.

Pekka

*****************************************************************************
 Pekka Koskinen                :)
 CIMO, P.O. Box 343            :)            "Mink{ sade kastelee,
 00531 Helsinki, FINLAND       :)            sen Dry Vodka kuivaa."
 tel [phone]       :)
 fax [phone]       :)       (Leo Lastum{ki Lampaansy|jiss{)
=========================================================================
Date:         Tue, 14 Dec 1993 16:20:28 GMT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Richard Saunders, Computer Centre" <[e-mail]>
Organization: University Of East London
Subject:      Re: Data Base Size?

> We currently have a database file about the size of 1.8MB, should I be
> worried about this size?  Is there ways to cut down the size?
>



I would only worry if you start getting problems: Access seems to use
a lot of space and this looks fairly reasonable. You could try the
"Compact Database" command from the opening file menu, especially if
you have modified the database structure recently.
=========================================================================
Date:         Tue, 14 Dec 1993 13:09:30 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Harry Yeatts <[e-mail]>
Subject:      Re: Passing valueS from an input box
In-Reply-To:  Message of Tue,
              14 Dec 1993 07:28:57 -0800 from <[e-mail]>

On Tue, 14 Dec 1993 07:28:57 -0800 John von Colditz said:
>Harry,
>
>If you wanted a user to be able to enter three values in an input box
>(1,2,3) you would need to bring the values back as a string, and then
>parse the string into the underlying numbers.  Commas in numbers should
>only be there as a thousands seperator (US) or decimal point (Europe).


Thanks for your reply, John.

The three numbers could be single, double, or triple digits (the exercise
is for the user to enter three temperatures...i.e., 5 65 101). Even when
I only put spaces between them, the return value reads 565101.

I wouldn't know where to separate them because they could be the above OR
56 51 01, etc.

Any other ideas?

P.S. The book I'm using called this a SIMPLE procedure. I'm really looking
forward to the difficult ones ;)

Harry Yeatts (HYEATTS)                INTERNET: VTVM1.CC.VT.EDU
Virginia Tech                         BITNET: VTVM1
Blacksburg, Virginia                  PHONE: [phone]
=========================================================================
Date:         Tue, 14 Dec 1993 13:19:13 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: Data Base Size?
In-Reply-To:  Message of Tue,
              14 Dec 1993 16:20:28 GMT from <[e-mail] .UK>

The Compact Database command also eliminates temporary objects created
when you use (I assume) Wizards or when you create forms, macros, modules,
etc. and then delete them.

Which leads me to an interesting question...if Access doesn't get rid
of these things till you compact the database, why can't you <un>delete
them?

Just a thought...

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Tue, 14 Dec 1993 15:04:48 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Passing valueS from an input box
In-Reply-To:  <[e-mail]> from "Harry Yeatts" at Dec 14,
              93 01:09:30 pm

Harry,

I will guess you are reading the value of the control into a variable
that is dimensioned as a number.  If you read it into a string, you get
back a string.  Try this experiment.  Assume your form is named Form1
and the input field is named Field1.  Type 1,2,3,45 into your input
field.  In the on exit property of Field1, put =FOO().

Function FOO()
  dim strT as String
  dim fltF as Float
  dim db as database
  dim frmF as form

  Set db = CurrentDB()
  Set frmF = forms!Form1

  strT = frmF!Field1
  fltT = frmF!Field1

  msgbox strT
  msgbox fltF
End Function
(5 lines up should be fltF = ... I hate vi!!!)

This will give you two message boxes.  The first will have the string
"1,2,3,45".  The second will have the float 12345.  To work with
strings, you have to read in strings.

Hope this clears things up.

John
[e-mail]
=========================================================================
Date:         Tue, 14 Dec 1993 15:16:52 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Scroll bars/borders
In-Reply-To:  <[e-mail]> from "[e-mail]" at
              Dec 14, 93 08:50:48 am

Jason,

If you are looking at the subform in datasheet view, I don't believe you
can get rid of the scroll bars/record selectors.

To get rid of the border on the Subform/report control, and set the
border to clear (on the properties list).

John

[e-mail]
=========================================================================
Date:         Tue, 14 Dec 1993 17:33:55 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Malaspina News Gateway <[e-mail]>
Subject:      Re: Passing valueS from an input box

From: [e-mail] (Ron Apland)

> The three numbers could be single, double, or triple digits (the exercise
> is for the user to enter three temperatures...i.e., 5 65 101). Even when
> I only put spaces between them, the return value reads 565101.
>
> I wouldn't know where to separate them because they could be the above OR
> 56 51 01, etc.
>
> Any other ideas?

I just tried the following:

Function inp ()
      v = InputBox$("Enter values")
      v1 = Format$(v)
End Function

to 5 45 67 I get:
print v
5 45 67
print v1
5 45 67

and to 5,45,67 I get:
print v
5,45,67
print v
5,45,67

Just look for the commas or spaces and pull out what is between using
Left$(), Mid$(), and Right$().

Ron
--------------------------------------------------------------------------------
Received: by mala.bc.ca (MX V3.3 VAX) id 22869; Tue, 14 Dec 1993 17:02:19 PST
To: [e-mail]
=========================================================================
Date:         Wed, 15 Dec 1993 10:49:30 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Michael Gordon <[e-mail]>
Subject:      FIND defaults

I use FIND quite a bit, but not precisely the way ACCESS defaults to.
By default, ACCESS gives me Current Field while I always want All Fields.
Similarly, ACCESS gives me Match Whole Field while I always want Any Part of
Field. If there's way to set the defaults so I automatically get All Fields and
Any Part of Field, I haven't found it. Any thoughts?

Michael

Michael D. Gordon
CIS: 71053,471
Internet: [e-mail]
Date sent:  15-DEC-1993 10:49:29
=========================================================================
Date:         Wed, 15 Dec 1993 08:04:36 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: FIND defaults
In-Reply-To:  <[e-mail]> from "Michael Gordon" at Dec
              15, 93 10:49:30 am

>
> I use FIND quite a bit, but not precisely the way ACCESS defaults to.
> By default, ACCESS gives me Current Field while I always want All Fields.
> Similarly, ACCESS gives me Match Whole Field while I always want Any Part of
> Field. If there's way to set the defaults so I automatically get All Fields
 and
> Any Part of Field, I haven't found it. Any thoughts?
>

Michael,

The Find methods are designed to get one record at a time.  What you
need to do is use queries to get multiple records with similar
characteristics.  You can use parameter queries to select parts of a
field.  If you are working with a dynaset that is associated with a form
or report, use the filter method to restrict the dynaset.

Hope this helps.

John
[e-mail]
=========================================================================
Date:         Wed, 15 Dec 1993 08:56:25 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Thornton Prime <"Thorton_~Prime_at_lmu-acad1"@LMUMAIL.LMU.EDU>
Subject:      Re: Data Base Size?

Jason Beatty asked:

>Also thanks for the input on (Attaching Access Tables), I am tring to
>use a subform, but I can't get rid of the borders or scroll bars, does
>anyone have a suggestion?

In your main form, in design mode, select the subform.  There you can change the
properties of the subform, including whether or not to display the border.  Make
sure also that the size of your subform is the same size as the room you have
allocated for it on your main form (otherwise you'll get scroll bars).

Thornton Prime
=========================================================================
Date:         Wed, 15 Dec 1993 08:59:33 +0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         al berni <[e-mail]>
Subject:      Re: FIND defaults

On Wed, 15 Dec 1993, Michael Gordon wrote:

> I use FIND quite a bit, but not precisely the way ACCESS defaults to.
> By default, ACCESS gives me Current Field while I always want All Fields.
> Similarly, ACCESS gives me Match Whole Field while I always want Any Part of
> Field. If there's way to set the defaults so I automatically get All Fields an
d
> Any Part of Field, I haven't found it. Any thoughts?

Check under the View/Options/General menu for Default Find/Replace
Behavior and change it to General Search from Fast Search.

-Al
=========================================================================
Date:         Wed, 15 Dec 1993 13:52:03 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Harry Yeatts <[e-mail]>
Subject:      Re: Passing valueS from an input box
In-Reply-To:  Message of Tue,
              14 Dec 1993 17:33:55 PST from <[e-mail]>

Thanks, Ron and John, for your suggestions.

Thought you might like to see the exercise itself:

"Write a simple procedure (using InputBox) that asks the user for the previous
three days' temperatures (stored in the Single variables t1, t2, and t3).
Compute the average temperature and print (using MsgBox) "It's cold!" if
the average is less than freezing."

It occurred to me right off that the user could indeed list temperatures
like: 7 17 15    or   99 101 100    in the input box. I'm still not familiar
enough with the left(), etc., commands to find spaces or commas, and obviously.
just moving two spaces to the left or right won't do it.

Like I said, I solved this by calling three separate input boxes, with the
return value from the first being t1, the second being t2, etc. But maybe
there's a more elegant way to handle this.

Anyway, thanks much for your help.

Harry Yeatts

Harry Yeatts (HYEATTS)                INTERNET: VTVM1.CC.VT.EDU
Virginia Tech                         BITNET: VTVM1
Blacksburg, Virginia                  PHONE: [phone]


=========================================================================
On Tue, 14 Dec 1993 17:33:55 PST Malaspina News Gateway said:
>From: [e-mail] (Ron Apland)
>
>> The three numbers could be single, double, or triple digits (the exercise
>> is for the user to enter three temperatures...i.e., 5 65 101). Even when
>> I only put spaces between them, the return value reads 565101.
>>
>> I wouldn't know where to separate them because they could be the above OR
>> 56 51 01, etc.
>>
>> Any other ideas?
>
>I just tried the following:
>
>Function inp ()
>      v = InputBox$("Enter values")
>      v1 = Format$(v)
>End Function
>
>to 5 45 67 I get:
>print v
>5 45 67
>print v1
>5 45 67
>
>and to 5,45,67 I get:
>print v
>5,45,67
>print v
>5,45,67
>
>Just look for the commas or spaces and pull out what is between using
>Left$(), Mid$(), and Right$().
=========================================================================
Date:         Wed, 15 Dec 1993 20:44:03 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Adam Cohen <[e-mail]>
Subject:      using Access referential integrity

Does anyone know of a way to define a referential constraint between
a _non-key_ field in a "parent" table to a primary key in a "child"
table?

Access seems to only provide referential integrity when the _key_
field of the parent is used for the constraint.

I've even tried defining a unique index on the non-key field in the
parent, but that doesn't seem to make a difference.

thanks

  Adam
=========================================================================
Date:         Wed, 15 Dec 1993 20:47:11 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Adam Cohen <[e-mail]>
Subject:      ongoing code maintenance

I wonder how people are dealing with the problem of having code and
data merged in a single .MDB file.

What do you do once a database is in production and you need to release
a software update?

I've read some about setting up a CodeDB that contains Access Basic code
to manipulate CurrentDB.  Is this the only way?  Unfortunately, most of
my code is in macros, not Access Basic.  That approach also doesn't address
the need to ship out a change such as a form or report.

thanks

  Adam
=========================================================================
Date:         Thu, 16 Dec 1993 08:32:58 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: ongoing code maintenance
In-Reply-To:  Message of Wed, 15 Dec 1993 20:47:11 PST from <ISCAAC@UCCVMA>

Well, one possibility would be to ship the update in an .mdb by itself,
then have the users import the object into their .mdb...only feasible
if the users are using Access themselves, I would imagine (i.e., I don't
know if this would work with the ADK).

Conversely, you could ship the .mdb ready to run in the new version and
let the users import their tables into the new .mdb.

Obviously this would necessitate a little working knowledge of Access on
the part of the user...

As to your other question, the code could reside in one .mdb and the data
in another if the code .mdb <attached> to the tables in the data .mdb.  Not
sure how well this would work, as I seem to recall some limitations to
using attached tables vs. integral tables.

HTH...I started developing Access front-ends in VB 3.0 to avoid this kind
of problem, personally.  Still not sure if it was <entirely> worth the effort,
but at least I can distribute stand-alone apps without having to bother with
the ADK.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Thu, 16 Dec 1993 07:02:01 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Bill Stewart <[e-mail]>
Subject:      Re: ongoing code maintenance

One scheme I've herd of to help deal with updates is to create two
databases.  One database has only tables and data, the other has all of
your forms, macros, etc.

This strategy allows for you to install the data .mdb file on a network and
then distribute the working forms and stuff to the user to either run over
the net or on their standalone pc's
=========================================================================
Date:         Thu, 16 Dec 1993 10:54:24 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dave Finley <[e-mail]>
Subject:      Re: ongoing code maintenance

Bill Stewart <[e-mail]> says ..

One scheme I've herd of to help deal with updates is to create two
databases.  One database has only tables and data, the other has all of
your forms, macros, etc.

This strategy allows for you to install the data .mdb file on a network and
then distribute the working forms and stuff to the user to either run over
the net or on their standalone pc's


Bill, and All:

The 2 .MDB (forms.MDB and data.MDB) strategy does simplify making changes
to forms, macros, ...  But it is not a totally "bulletproof" solution. For
one, if you need to make data table changes (adding new tables, adding /
changing fields in an already existing table), you still have to go into
the data.MDB and change it. This can get complex.

Probably the best solution would be a "data-table update" wizard, which you
could provide with a "script" of changes, which can then be made to your
data.MDB. Does such a wizard currently exist? Is there a better solution?


Dave Finley
[e-mail]
=========================================================================
Date:         Thu, 16 Dec 1993 08:23:03 PST
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Re: ongoing code maintenance
In-Reply-To:  <[e-mail]>; from "Adam Cohen" at Dec
              15, 93 8:47 pm

> I wonder how people are dealing with the problem of having code and
> data merged in a single .MDB file.
>
> What do you do once a database is in production and you need to release
> a software update?
>
> I've read some about setting up a CodeDB that contains Access Basic code
> to manipulate CurrentDB.  Is this the only way?  Unfortunately, most of
> my code is in macros, not Access Basic.  That approach also doesn't address
> the need to ship out a change such as a form or report.
>
> thanks
>
>   Adam

Adam, actually, having code and data merged in a single file, far from
being a problem, can actually be a solution. It all depends on what you can
get away with in your environment. In my case, I have about 4-8 users running
from a single .MDB file on a network drive. I keep a master copy of the
application objects (forms, macros, functions, reports, etc.) in a local
database. From there, I develop upgraded objects, create new ones, etc.. When
it's time to update the actual application, I can then just export those
objects to the production database (which is backed up nightly). The users
can be on-line, doing other things, while I'm actually updating various
parts of the application.

There's certainly some drawbacks to doing things this way, but it at least
addresses your question. As for having most of your code in macros, it would
be a good idea to re-write those macros as functions. Thanks to the DoCmd
command in Access Basic, there's nothing you can't do in functions. Otherwise,
your users will inevitably get errors of some kind or another.

I was just thinking: in the case where your users aren't as captive as
mine are (probably more likely), how can you ship out updates? In this case,
you'd probably _have_ to look at separating the code and data. The thing
I don't like about that is that, while Microsoft claims it doesn't matter,
attaching tables _does_ incur a performance hit vs. having the tables of
data in the same .MDB. Maybe this will improve with v2.0 ... ??

--
TONY HAMILTON ==================================================
 Intel Corporation            | voice: 916-356-3070
  Folsom Engineering Services | mailstop: FM2-17
   PC Applications            | email: [e-mail]
================================================================
=========================================================================
Date:         Thu, 16 Dec 1993 12:04:29 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Louis Jezsik <[e-mail]>
Subject:      Date input

I am trying to get access to permit a date followed by a character
but can't seem to figure out how to do it.  The format is (yyyy) so
I have a print-out of (1993).  What I want is an OPTION to have a
date of (1993a) or (1993b).  Yes, I am dealing with publications.
If I use the format (yyyy/a), I get exactly that: a date with an 'a'
following it.  Hmmm.  Anyone have a suggestion.
Thanks
Louis
[e-mail]
=========================================================================
Date:         Thu, 16 Dec 1993 11:43:42 CST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Richard Moldwin <[e-mail]>
Subject:      Re: using Access referential integrity
In-Reply-To:  Your message of Wed, 15 Dec 1993 20:44:03 PST

Adam, I have not had any problems doing creating ref integ. relationships
between fields.  Are you sure that both fields are set to the same data type,
e.g. both set to long?  This was a problem for me when I started  using
Access.  Good Luck.
--Rich Moldwin
=========================================================================
Date:         Thu, 16 Dec 1993 10:27:20 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: ongoing code maintenance
In-Reply-To:  <[e-mail]> from "Adam Cohen" at Dec 15,
              93 08:47:11 pm

Adam,

Put all of your tables in a seperate MDB, and attach them from your
working MDB.  I usually give the data MDB a different file extension, to
further hide it from users.

CodeDB() and CurrentDB() are functions.  CurrentDB() returns a database
object for the currently open database.  CodeDB() returns a database
object also.  If you are running your code from a library, it returns a
database object for the library.  If you are running code from a user
database, it returns the same database object as CurrentDB().  Subtle,
and somewhat confusing.

John
[e-mail]
=========================================================================
Date:         Thu, 16 Dec 1993 10:32:14 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: using Access referential integrity
In-Reply-To:  <[e-mail]> from "Adam Cohen" at Dec 15,
              93 08:44:03 pm

>
> Does anyone know of a way to define a referential constraint between
> a _non-key_ field in a "parent" table to a primary key in a "child"
> table?
>
> Access seems to only provide referential integrity when the _key_
> field of the parent is used for the constraint.
>
> I've even tried defining a unique index on the non-key field in the
> parent, but that doesn't seem to make a difference.
>
> thanks
>
>   Adam
>
Adam, you are correct.  Access only supports referential integrity on
key fields in the parent.  Sorry

John
[e-mail].
=========================================================================
Date:         Thu, 16 Dec 1993 14:58:39 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Help!  I'm a beginner!

I am a novice at using MS Access.  My question may seem simple to those of you
who are expert database handlers, but I will pose it just the same.  Clear
step-by-step instructions would be appreciated, if possible.

I have several tables (used to be in dBase 4) that I use to track the computer
inventory in our school.  Each machine is given a unique number (SBA_NUM in my
database) which is used to identify it.  I have several tables in the database,
including PS2 (a listing of all PS/2s, obviously), SCH_PRTS (a listing of all
newer dot-matrix and laser printers), LAPTOPS, etc.  One field in each table
is the SBA_NUM and another is the ROOM.  Each ROOM may contain several SBA_NUMs
from different tables.

I want to print out a listing of what machines are in each room.  I have tried
to use the Help menu and the Cue Cards on creating relationships and running
queries, but I am lost!  The solution probably seems obvious to all of you, but
try as I might, I can't get this thing to work!  I have reached my frustration
point, so I thought I would send this to the list.

Any hints you can give me would be much appreciated!


Amy C. Park
Dean's Office, School of Business Administration
University of Connecticut
368 Fairfield Rd., U-41D
Storrs, CT  06269-2041
[e-mail]
=========================================================================
Date:         Thu, 16 Dec 1993 15:58:23 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jim Foley <[e-mail]>
Subject:      Re: Access, Oracle and Vax

Frank,

I was wondering if you could post a summary of the answers you get back
to the list or to me personally?  I am looking into similar combinations
here at Bentley and would like to hear of any successes or horror stories.
Thanks in advance.

Jim Foley
Manager of Data Administration
Bentley College
Waltham, MA  02154-4705
[phone]
[e-mail]
=========================================================================
Date:         Thu, 16 Dec 1993 14:44:13 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Louis Jezsik <[e-mail]>
Subject:      How do I input a phone number

I want to have a place for phone numbers in my database.  The area code
field is easy enough but how do you handle ###-####?  When I set the number
in this format Access returns with #-# and I haven't the slightest idea
what it is trying to do.  The PIM program is no help at all.  It has a
text field with 50 characters for the (at the most) 13 characters needed.
Go figure.  So, anyone have a solution to this problem?
Thanks
Louis
[e-mail]
=========================================================================
Date:         Thu, 16 Dec 1993 18:18:36 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Ted Atkinson <[e-mail]>
Subject:      Access on OS/2 or NT I am running Access on OS/2 2.1 using
              WIN/OS2. It seems to have some
In-Reply-To:  <[e-mail]>

problems displaying its windows correctly. I sometime get pieces of windows
remaining in the background. The foreground window is usually O.K. I haven't
had many problems with it crashing, but the way it displays is messy.

Ted Atkinson
Systems Analyst
University of Maine System
Orono, Maine
[e-mail]
=========================================================================
Date:         Thu, 16 Dec 1993 16:02:01 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: How do I input a phone number
In-Reply-To:  <[e-mail]> from "Louis Jezsik" at Dec 16,
              93 02:44:13 pm

>
> I want to have a place for phone numbers in my database.  The area code
> field is easy enough but how do you handle ###-####?  When I set the number
> in this format Access returns with #-# and I haven't the slightest idea
> what it is trying to do.  The PIM program is no help at all.  It has a
> text field with 50 characters for the (at the most) 13 characters needed.
> Go figure.  So, anyone have a solution to this problem?
> Thanks
> Louis
> [e-mail]
>
Louis,

You are not inputing a phone number, you are inputting a phone string.
The approach that I have taken is to create a function called ValidPN(),
that is attached to the OnExit property of the text box.  Usually I pass
it the control, and the form.  The pseudo-code for the function is
something like this (it gets much more complex for international phone
numbers!)

Check for nulls
Check length - if less than 7, notify user and cancel event
    if > 14 (1-234-567-8901), notify user and cancel event
Strip out leading "1-"
Strip out "-"
If it's numeric and length = 7 or 10, redisplay, properly formatted, and
   move on
else
   notify user and cancel event
Done

This may seem a bit clumsy, but it works!

Good luck.

John
[e-mail]
=========================================================================
Date:         Thu, 16 Dec 1993 16:11:56 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Date input
In-Reply-To:  <[e-mail]> from "Louis Jezsik" at Dec 16,
              93 12:04:29 pm

>
> I am trying to get access to permit a date followed by a character
> but can't seem to figure out how to do it.  The format is (yyyy) so
> I have a print-out of (1993).  What I want is an OPTION to have a
> date of (1993a) or (1993b).  Yes, I am dealing with publications.
> If I use the format (yyyy/a), I get exactly that: a date with an 'a'
> following it.  Hmmm.  Anyone have a suggestion.
> Thanks
> Louis
> [e-mail]
>
Louis,

Read your date in as a string, rather than a variant.  Use a function in
the OnExit property of the text box to edit it.

John
[e-mail]
=========================================================================
Date:         Thu, 16 Dec 1993 15:48:22 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Help!  I'm a beginner!
In-Reply-To:  <[e-mail]> from "[e-mail]"
              at Dec 16, 93 02:58:39 pm

Amy,

You haven't exactly set this up to make it easy for yourself!  What you
want to end up with is a table/dynaset that has Room Number, Equipment
Description (printer/laptop/PS2/etc.), SBA_NUM, etc.  With the structure
of your tables, you have no easy way to extract all of the data.  I
think I can give you the easiest, and ugliest solution.

1) Design a new table.  For fields, use the ones you want to appear in
   the report.  Make SBA_NUM the key field (I assume it's unique).

2) Build an append query that takes the correct data from each of your
   tables and mashes it into your new table.  You will probably want to
   build one query for each table, if you have to do the report
   frequently.  Run all of the queries.

3) Build your report, based on your table, or based on a query on the
   table.  Use the Wizard, and select a grouped report.  Group by room,
   and, if you want, equipment type.

4) Run your report.

At some point you are going to want to consider restructuring your
tables, so that your base table looks more like the table you are basing
the report on.  Post again when you decide to do it.

Good luck.

John
=========================================================================
Date:         Thu, 16 Dec 1993 16:22:04 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Access on OS/2 or NT I am running Access on OS/2 2.1 using
In-Reply-To:  <[e-mail]> from "Ted Atkinson" at Dec 16,
              93 06:18:36 pm

Ted,

Access is notoriously hard on poorly written video drivers.  Check with
your board manufacturer and get the latest version of the drivers.  If
you are having crashes in Access, this will probably solve that problem,
too.

Good luck.

John
[e-mail]
=========================================================================
Date:         Thu, 16 Dec 1993 17:46:50 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         B Jonathan Schuck <[e-mail]>
Subject:      Re: How do I input a phone number
In-Reply-To:  <[e-mail]> from "Louis Jezsik" at Dec
              16, 93 02:44:13 pm

>
> I want to have a place for phone numbers in my database.  The area code
> field is easy enough but how do you handle ###-####?  When I set the number
> in this format Access returns with #-# and I haven't the slightest idea
> what it is trying to do.  The PIM program is no help at all.  It has a
> text field with 50 characters for the (at the most) 13 characters needed.
> Go figure.  So, anyone have a solution to this problem?
> Thanks
> Louis
> [e-mail]
>

If you were using a text field, you could format it:

(@@@) @@@-@@@@ for phone plus area code

or

@@@-@@@@ for just a phone #
=========================================================================
Date:         Thu, 16 Dec 1993 18:07:02 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Brian Henning <[e-mail]>
Subject:      Re: ongoing code maintenance
In-Reply-To:  <[e-mail]>

On Wed, 15 Dec 1993, Adam Cohen wrote:

> I wonder how people are dealing with the problem of having code and
> data merged in a single .MDB file.
>

I wish Microsoft had designed the whole system around the concept of two
files make up a database, 1 for code objects (forms, macros, queries,
etc.) and the other purely for tables.  Please don't tell me one file is
an object oriented feature. It has nothing to do with that.  This is a
physical storage issue.

I live in the Bay area and have a client in Tucson with an Access based
system. All the various storage scenarios don't work very well for me.

1. Two database (one for tables and the other code related) - Lose all
referential integrity. Has a performance penalty (don't know if this is
true)? All the attached tables must be hard coded to a drive/directory
etc.

2. Library - Only good for modules. Cannot have a form in library bound to
a table in the data database. Cannot debug code when set up this way.

3. One database - Cannot ship your user a new release. Must either send
out patch database from which to import objects into the production
database or get a copy of the production database and install all the
changed objects.

I really get the impression sometimes that tool developers do a good job
of testing individual features in products but never build and maintain
real applications with their own tools.  If they did they would never have
released a product that's set up like this.

Don't get me wrong. I really like Access. I have built 4 significant
applications with it and am anxious for the next release.  This product is
the future, not the xBase stuff of Fox Pro.  I tried Paradox for Windows
and found it to be technically more elegant but even more guilty of the
"has anyone really built and maintained an application with this thing"
problem.  Since I'm on a roll. Hey Microsoft are you going to clean up
Menu bar handling in this next release?  Having to call the Windows API to
do simple things like checking and greying is a real kludge.

This next release of Access will really determine it's future.  Does it
stay in the realm of "end-user databases" or is it willing to give
developers a real platform to develop the client side of an application.
I'm looking down at an ad from Powersoft for their PowerMaker product
($99) and wondering if this would be a more appropriate product for
developing low-end client/server applications.

I digress. I'll be quiet now.

Brian Henning
=========================================================================
Date:         Fri, 17 Dec 1993 15:35:07 GMT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Richard Saunders, Computer Centre" <[e-mail]>
Organization: University Of East London
Subject:      Re: Help! I'm a beginner!

>
> I am a novice at using MS Access.  My question may seem simple to those of you
> who are expert database handlers, but I will pose it just the same.  Clear
> step-by-step instructions would be appreciated, if possible.
(Stuff deleted)

I'm also a fairly new Access user so I sympathize. I have a book
called "Understanding Microsoft Access" by Alan Simpson and on page
72 it says in big letters "Don't Use Multiple Tables to Categorize
Data...". That seems to me to be what you are doing.

If you could combine all your different tables into a single table
with a new field to show the type of printer, I think your problem
would be much easier. You could then use the Groups/Totals Wizard to
create a report grouped on room number. Have a good Christmas!
=========================================================================
Date:         Fri, 17 Dec 1993 08:41:15 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: ongoing code maintenance
In-Reply-To:  <[e-mail]> from "Brian Henning" at Dec 16,
              93 06:07:02 pm

>
> On Wed, 15 Dec 1993, Adam Cohen wrote:
>
> > I wonder how people are dealing with the problem of having code and
> > data merged in a single .MDB file.
> >
>
> I wish Microsoft had designed the whole system around the concept of two
> files make up a database, 1 for code objects (forms, macros, queries,
> etc.) and the other purely for tables.  Please don't tell me one file is
> an object oriented feature. It has nothing to do with that.  This is a
> physical storage issue.
>
> I live in the Bay area and have a client in Tucson with an Access based
> system. All the various storage scenarios don't work very well for me.
>
> 1. Two database (one for tables and the other code related) - Lose all
> referential integrity. Has a performance penalty (don't know if this is
> true)? All the attached tables must be hard coded to a drive/directory
> etc.
There may, in fact, be a performance penalty.  You _can_ maintain
referential integrity between tables.  I have several applications with
split code and data, and all maintain referential integrity.  You do not
have to hard code the drive/directory paths.  I have adopted the
strategy of validating all attachments on startup.  If they are invalid,
I go out to a table that maintains all of my paths to the data, and
attempt to reattach.  If this fails, the user uses the Windows common
dialogs to re-establish the paths to the data, and then reattaches the
files.  There is a very good article by Paul Litwin in the December
Smart Acces that reviews how to do this.
>
> 2. Library - Only good for modules. Cannot have a form in library bound to
> a table in the data database. Cannot debug code when set up this way.
Agreed that libraries are only good for modules.  That is what they were
designed for.  You can have a form in the code database bound to a table
in the data MDB.  Also agreed that debugging of libraries can be a pain.
>
> 3. One database - Cannot ship your user a new release. Must either send
> out patch database from which to import objects into the production
> database or get a copy of the production database and install all the
> changed objects.
I have done one single MDB update in the field, for users in Canada, and
it was a pain.  I created and update MDB that opened the old and new
MDB's on the user system.  It imported all of the tables to the new MDB,
used the Access Data Definition Language to re-establish the
relationships between tables in the new MDB.  It was not very much fun!
>
> I really get the impression sometimes that tool developers do a good job
> of testing individual features in products but never build and maintain
> real applications with their own tools.  If they did they would never have
> released a product that's set up like this.
Please remember the product is on version 1.1.  Microsoft is working on
SIGNIFICANT improvements.

Brian, I understand many of your frustrations, having endured many of
them myself.

Good luck.

John
[e-mail]
=========================================================================
Date:         Fri, 17 Dec 1993 11:54:30 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Amy C. Park" <[e-mail]>
Subject:      Thanks, everyone!

Wow!  I never expected to get that many responses to my question.  It does
sound like I should put all of my data into one big table - that will make
things a lot easier!  If I still have problems, I will write in again.

Thanks to everyone for all your help.  Have a great Christmas!!!  :-)

Amy C. Park
Dean's Office, School of Business Administration
University of Connecticut
368 Fairfield Rd., U-41D
Storrs, CT  06269-2041
[e-mail]
=========================================================================
Date:         Sat, 18 Dec 1993 10:07:03 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Stephen Hueners <[e-mail]>
Subject:      Calling Subs from OnOpen

I'm trying to run ABCode that parses a text file and retruns variables to
given fields in a given table. As such, I'm not interested in a return value
of a function (nor do I wish to pass arguments) so I percieve I must use a
Sub - but I don't see how to "Call" a sub from the OnOpen event.

When I change the code to "Function" and call with:
      OnOpen Proporty to "= ParseText()"
the empty argument list interfers with the arguments that the Declarations
send. Specifically, I'm declaring a user-defined data type.

I think my question boils down to how to call a Sub from an event....but I
could be off base with that as well.

THA
--steve...
=========================================================================
Date:         Sat, 18 Dec 1993 10:08:23 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Calling Subs from OnOpen
In-Reply-To:  <[e-mail]> from "Stephen Hueners" at Dec
              18, 93 10:07:03 am

>
> I'm trying to run ABCode that parses a text file and retruns variables to
> given fields in a given table. As such, I'm not interested in a return value
> of a function (nor do I wish to pass arguments) so I percieve I must use a
> Sub - but I don't see how to "Call" a sub from the OnOpen event.

Sorry, but you can only call macros and functions.  Functions will
always work where you have a sub.

>
> When I change the code to "Function" and call with:
>       OnOpen Proporty to "= ParseText()"
> the empty argument list interfers with the arguments that the Declarations
> send. Specifically, I'm declaring a user-defined data type.

I am a little unclear on what you are asking here.  If your user defined
type is declared in the declarations section of the module, all of the
functions in the module have access to it.  An empty argument list
should have no effect on the declaration.  ??

Steve, I hope this cleared things up a bit.  If not, please re-post

John
[e-mail]
=========================================================================
Date:         Sun, 19 Dec 1993 09:17:28 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Stephen Hueners <[e-mail]>
Subject:      Re: Calling Subs from OnOpen

>I am a little unclear on what you are asking here.

Sorry, in my attempt to be brief I sacrificed clarity.

>...An empty argument list should have no effect on the declaration.  ??

The empty aurgument list comes from the OpOpen property calling the
function.

Since all I'm trying to do is execute code that acts upon an
existing DOS file and returns values to a table with TBLNAME.ADDNEW method,
I have no need to pass arguments - hence OnOpen property reads:
   =functionname() --- empty argument list.

In order to define data type I must declare in Declarations and include as
argument. So declarations has:

TYPE data_structure
    From As String
    To As String
    ...
    ...
    ...
End Type

and the function begins with:

Function ParseHeader (var As Data_Structure)

so I can refer to var.From and so on. When code attempts to execute I get an
"Argument-count mismatch in On-Open expression" error. Thinking that the
empty arugment list from the calling property was interferring with
the passing of the user-defined data type argument, I have also attempted to
open the function with 2 arguments in it's list as:

Function ParseHeader (holder ByVal as String, var As Data_Structure)

but I get the same error.

Undoutedly something simple and likely that I'm trying to use a tool in a
way in which it was'nt intended...my trademark...so to restate my intent
should anyone care to redirect my efforts:

I'm trying to parse a text file and return data from that file to a table.

I'm using a user-defined data type so that I can assemble all the fields of
a given record before doing an Update.

I'm using the OnOpen property of a form to call the function because that
seems to be a likely event to use.

I don't think I need to send any arguments to the function nor do I need to
return a value as the result of the function...IOW the way I perceive it, my
code is a subroutine and does not evaluate to anything meaningful like SUM()
or DatePart().

....now i've probably been _too_ verbose.

thankx
--steve...

[e-mail]
=========================================================================
Date:         Sun, 19 Dec 1993 09:13:12 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Calling Subs from OnOpen
In-Reply-To:  <[e-mail]> from "Stephen Hueners" at Dec
              19, 93 09:17:28 am

Steve,

Now were getting somewhere!  You are making this more complex than it
needs to be.  Several points need to be made:

1) You are getting the "Argument-count mismatch..." message because the
   function is expecting one argument, and you are passing no argument,
   or two arguments.  But that's not the main problem.

2) You do not need to pass Data_Structure as an argument.  You need to
   declare the type in the declarations section of the module.  You then
   need to Dim it in your module, ie.

   Declarations
   Type Data_Structure
      From as String
      To as String
      ....
   End Type

   Function ParseHeader()
      Dim Foo as Data_Structure
      < Do work here >
   End function

   If this is unclear, look at ORDENTRY.MDB from the Access distribution
   disks.  Look at the module Windows API Utilities.  First, look at the
   WU_RECT data type.  Then look at the function wu_CenterDoc, where the
   variables r, and rDesk are Dim'ed as WU_RECT.

I hope this all makes sense.  Good luck.

John
[e-mail]
=========================================================================
Date:         Sun, 19 Dec 1993 14:42:10 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Converted from PROFS to RFC822 format by PUMP V2.2X
From:         Albert Yoder <[e-mail]>
Subject:      Command confirmation request (60A4A3)

OK

Dr Al Yoder, Southside Virginia Community College
John H Daniel Campus, Keysville, VA 23947
Phone: [phone]  Fax: [phone]
*** Reply to note of 12/19/93 14:36
X-Delivery-Notice:  SMTP MAIL FROM does not correspond to sender.
Received: from INDYCMS.IUPUI.EDU (LMAIL@INDYCMS) by VCCSCENT.BITNET (Mailer
 R2.07) with BSMTP id 5735; Sun, 19 Dec 93 14:36:44 EST
Received: from INDYCMS.IUPUI.EDU (NJE origin LISTSERV@INDYCMS) by
 INDYCMS.IUPUI.EDU (LMail V1.1b/1.7e) with BSMTP id 7735; Sun,
 19 Dec 1993 14:36:29 -0500
Date:         Sun, 19 Dec 1993 14:36:29 -0500
From:         BITNET list server at INDYCMS (1.7f) <[e-mail]>
Subject:      Command confirmation request (60A4A3)
To:           [e-mail]
X-LSV-ListID: ACCESS-L

Your command:

                          SUBSCRIBE ACCESS-L Al Yoder

has been received.  You must now reply to this  message (as explained below)
to complete your subscription. The purpose of this confirmation procedure is
to check that  the address LISTSERV is about  to add to the list  for you is
working properly. This is a typical  procedure for high-volume lists and all
new subscribers  are subjected to  it - no offense  meant. We have  tried to
make this confirmation as simple and painless as possible, and apologize for
the inconvenience.

With most  mail programs, you  can confirm the  command by simply  using the
"reply"  function, without  including  the original  text,  and typing  "ok"
(without the quotes) as the text of  your message. Just "ok" - do not retype
the command  or anything else.  If this does not  work, you will  receive an
error  message. In  this  case, send  "ok 60A4A3"  instead,  using the  same
procedure with which you  sent the command you are now  asked to confirm. In
other words, with most mail programs you will only need to type "ok", but if
you are unlucky you may have to retype the confirmation code as well.

Finally, your command will be automatically  cancelled if you do not confirm
it within 48h. After  that time, you must start over  and resend the command
to get a new  confirmation code. If necessary, wait until  you know you will
be able  to reply  in time. If  on the  other hand you  change your  mind or
realize you made  a mistake when typing  the command, you do not  need to do
anything  - it  will expire  on its  own  in 48h  and, if  you discard  this
message, there is no risk of confirming it by accident.
=========================================================================
Date:         Sun, 19 Dec 1993 15:30:20 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Howard Meisner <[e-mail]>
Subject:      Re: Command confirmation request (60A4A3)

ok
=========================================================================
Date:         Mon, 20 Dec 1993 08:31:47 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "John A. Olson" <[e-mail]>
Subject:      Re: Calling Subs from OnOpen

>I'm trying to run ABCode that parses a text file and retruns variables to
>given fields in a given table. As such, I'm not interested in a return value
>of a function (nor do I wish to pass arguments) so I percieve I must use a
>Sub - but I don't see how to "Call" a sub from the OnOpen event.
>
>When I change the code to "Function" and call with:
>      OnOpen Proporty to "= ParseText()"
>the empty argument list interfers with the arguments that the Declarations
>send. Specifically, I'm declaring a user-defined data type.
>
>I think my question boils down to how to call a Sub from an event....but I
>could be off base with that as well.
>
>THA
>--steve...
>
>

This is just a thought.  AB is an event driven language which means that
once a statement begins to execute, the function continues immediately to
the next line  before the first line has even completed.  If you have not
managed to capture the DOS operation within a loop in such a way to "stall"
the function,  the arguments you are expecting to get from your DOS text
file will not be available to the function.  If, for instance, you are using
the "shell" function to run a DOS app,  you need to have that shell
operation complete its task before continuing.  There is a way to do this.
One of the Windows API functions can monitor a given task.  It's called
GetModuleUsage.  If the above situation is applicable to your problem, send
another message and I'll provide the code to allow the "stall" to occur.

Good luck!

John
=========================================================================
Date:         Mon, 20 Dec 1993 15:47:00 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Ellington, Robert W (Bob)" <[e-mail]>
Subject:      Remove characters from a string

Hello,
     I have written a routine that will strip out an unwanted character from
a string, and have written it so that I can send the character that I want
removed from the string.  Now, what I want is to have the routine so that I
can tell it that I want to remove multiple unwanted characters from the
string.  I want to make a call like this:

newstring = removechar(oldstring, list_of_unwanted_char)

Instead of having to do this:

newstring = removechar(oldstring, "&")
newstring = removechar(newstring, "-")
etc.....


I want the list to be able to be any number of characters (1 to n)

I have thought about just passing a concatenated string of my unwanted
characters and then parsing that string 1 character at a time, but I figured
that there had to be a better way.

list_of_unwanted_char = "&$-@"
Insided removechar I could loop reading the mid for 1 char at a time.

Any ideas?

Thanks in advance
Bob Ellington
[e-mail]
=========================================================================
Date:         Mon, 20 Dec 1993 13:36:14 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Brian Henning <[e-mail]>
Subject:      Record Locking

Hi,

I'm developing a multi-user system and plan on using the lock edited
record option on the updating forms. When I've tested this feature its
works as advertised but I have one problem.  If user A is editing a record
and B comes along and tries to edit the same record the only indication
they get is a beep when they try to enter something into the form. I don't
have record selectors on (since it's a one record form) so they don't even
get that little circle thing when the record is locked. Is there some way
I could give them a polite dialog box telling them the record is locked
at the moment?

Brian H.
=========================================================================
Date:         Mon, 20 Dec 1993 16:55:31 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Re: Remove characters from a string

>
>Hello,
>     I have written a routine that will strip out an unwanted character from
>a string, and have written it so that I can send the character that I want
>removed from the string.  Now, what I want is to have the routine so that I
>can tell it that I want to remove multiple unwanted characters from the
>string.  I want to make a call like this:
>
>newstring = removechar(oldstring, list_of_unwanted_char)
>
>Instead of having to do this:
>
>newstring = removechar(oldstring, "&")
>newstring = removechar(newstring, "-")
>etc.....
>
>
>I want the list to be able to be any number of characters (1 to n)
>
>I have thought about just passing a concatenated string of my unwanted
>characters and then parsing that string 1 character at a time, but I figured
>that there had to be a better way.
>
>list_of_unwanted_char = "&$-@"
>Insided removechar I could loop reading the mid for 1 char at a time.
>
>Any ideas?
>
>Thanks in advance
>Bob Ellington
>[e-mail]
>

Try the following:

Function RemoveChar (OldStr As String, UnWanted As String)
    Dim OneChar As String, Position As Integer
    NewStr = ""
    For Position = 1 To Len(OldStr)
        OneChar = Mid$(OldStr, Position, 1)
        NewStr = NewStr + IIf(InStr(1, UnWanted, OneChar) = 0, OneChar, "")
    Next Position
    RemoveChar = NewStr
End Function


It works for me, although it will not as written handle embedded quotes.
Anyone care to enhance it to do so?

Bob Oberst
[e-mail]
=========================================================================
Date:         Tue, 21 Dec 1993 20:42:48 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Adam Cohen <[e-mail]>
Subject:      On Menu and Modality

I have an application with a custom menu bar that is established
with a menu bar macro and the OnMenu event set for all forms in
the system.  Everything points to the same menu macro.

The problem is that my first form displayed has to be modal
and it appears that the OnMenu event doesn't occur until after
the form is disposed of.

So while the user is looking at the initial form, and until they
make a selection, they are seeing the default Access menu above
the form, even though they can't get to it.  It would be nice to
have my menu show up first.  Is this possible?

  Adam
=========================================================================
Date:         Wed, 22 Dec 1993 11:47:59 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Corey Lawson <[e-mail]>
Subject:      Good books on Macro and/or AccessBasic programming?

the subject says it all...

Thanks.

-Corey Lawson
[e-mail]
        or
[e-mail]
=========================================================================
Date:         Wed, 22 Dec 1993 15:59:10 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Adam Cohen <[e-mail]>
Subject:      ADK SetupWizard

When a custom setup created by SetupWizard creates the Program Manager
item for my application, it puts "/INI <INIfilename>" on the command
line.  The <INIfilename> is not qualified by a path; it assumes that
the location will be the current directory.

When this is left alone, it seems that the TitleBar option (at least)
in the .INI file is ignored.  But if I change the progman item to put
the fully qualified .INI file pathname (e.g., C:\APP\APPLET.INI) on
the commandline, TitleBar is recognized and used.

Has anyone else seen this behavior?  I didn't find anything in the
ADK readme or in MSDN.
thanks

  Adam
=========================================================================
Date:         Wed, 22 Dec 1993 21:24:14 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Gad Malamed <[e-mail]>
Subject:      calculated fields

I am having trouble using a calculated field in a form. I want the newly
calculated value to go into the table to be stored, not just to appear on the
form one time. The field it is going into is in the same table as the form
(in other words, there is only one form and only one table involved). I have
no trouble calculating the value interactively on the form, and I have
created a macro that actually updates the field, as planned. But I can only
add one record; then the macro locks up. Everytime I press enter to get to
the next record, the status line says "calculating"; in some instances,
depending on what macro I use, I get the message "can't SetValue", or "cant
update field while validating value". There is no validation for the
field(s). By the way, the fields are logical, y/n. I can easily enough create
an update query that recalcs all the values, but would prefer this method of
doing it on the form.
Any help appreciated. I also strongly prefer macros; not a Basic routine at
this time. Thank you.
=========================================================================
Date:         Thu, 23 Dec 1993 08:30:53 MET
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         DeJean <[e-mail]>
Subject:      Access Basic and Forms

I have been looking into the manual for this, but couldn't find it (maybe
overlooked it), so if it is in it, just point to the page. ;-)

I'm trying to write a module. On a certain moment I would like to search
for a record in a table. WHen I use the FindFirst thin, I have to specify a
criteria.
criteria = "[FieldName] like '*test*'".
What if I want this 'test'-word to be a control of a form which is
currently open? I have tried things like
criteria = "[FieldName] like '*' & Forms!FormName!Control & '*'"
But this doesn't seem to work. Anybody with a solution?

Thanks in advance,

--
DeJean.

Vrije Universiteit Brussel
Belgium
=========================================================================
Date:         Thu, 23 Dec 1993 08:53:17 -0400
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jon O'Donnell <[e-mail]>
Subject:      Re: Access Basic and Forms

> I'm trying to write a module. On a certain moment I would like to search
> for a record in a table. WHen I use the FindFirst thin, I have to specify a
> criteria.
> criteria = "[FieldName] like '*test*'".
> What if I want this 'test'-word to be a control of a form which is
> currently open? I have tried things like
> criteria = "[FieldName] like '*' & Forms!FormName!Control & '*'"
> But this doesn't seem to work. Anybody with a solution?


If I understand your problem correctly, you want to open a new form with a
given set of records that meet a condition specified as a value in another form
field.  I did something similar using a macro:

1.  Specify and OpenForm action
2.  Give the desired form name and open mode
3.  As the condition use:
         [Field Name] Like "*" & [Control Name or Prompt] & "*"


Hope this helps


Jon O'Donnell
[e-mail]
=========================================================================
Date:         Thu, 23 Dec 1993 17:09:55 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Good books on Macro and/or AccessBasic programming?
In-Reply-To:  <[e-mail]> from "Corey Lawson" at Dec 22,
              93 11:47:59 am

Access Basic Cookbook by Chris St. Valentine, available at the
University Bookstore.

John
[e-mail]
=========================================================================
Date:         Fri, 24 Dec 1993 17:50:27 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Robert Reinecke <[e-mail]>
Subject:      ACCESS BASIC books

Perry, Greg. "Access Programming by Example." Carmel, IN: QUE
    Corporation, 1993
    ISBN: 1-56529-305-3
    $27.95


=================================================================
Bob Reinecke                     Department of Speech and Theatre
                                 Kutztown University
                                 Kutztown, PA  19530
[phone]
=================================================================
=========================================================================
Date:         Sat, 25 Dec 1993 07:31:55 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Access Basic and Forms
In-Reply-To:  <[e-mail]> from "DeJean" at Dec 23,
              93 08:30:53 am

DeJean,

If I understand your message correctly, what you want to do is open a
form, have the user input some criteria in a text box, and then find the
record in the underlying dynaset that matches that criteria.  If the
form is already open, you have to do the FindFirst on the dynaset and
then resynch the form and the dynaset.

Forms![MyForm].Dynaset.FindFirst Criteria
Forms![MyForm].Bookmark = Forms![MyForm].Dynaset.Bookmark

Look up the Dynaset property and the bookmark property in the help
files.

Hope this helps.

John
[e-mail]
=========================================================================
Date:         Sat, 25 Dec 1993 07:43:36 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: calculated fields
In-Reply-To:  <[e-mail]> from "Gad Malamed" at Dec 22,
              93 09:24:14 pm

>
> I am having trouble using a calculated field in a form. I want the newly
> calculated value to go into the table to be stored, not just to appear on the
> form one time. The field it is going into is in the same table as the form
> (in other words, there is only one form and only one table involved). I have
> no trouble calculating the value interactively on the form, and I have
> created a macro that actually updates the field, as planned. But I can only
> add one record; then the macro locks up. Everytime I press enter to get to
> the next record, the status line says "calculating"; in some instances,
> depending on what macro I use, I get the message "can't SetValue", or "cant
> update field while validating value". There is no validation for the
> field(s). By the way, the fields are logical, y/n. I can easily enough create
> an update query that recalcs all the values, but would prefer this method of
> doing it on the form.
> Any help appreciated. I also strongly prefer macros; not a Basic routine at
> this time. Thank you.
>
Sorry, Gad, but I'm a Basic kind of guy, so I'll give you a Basic
solution.  Let's assume your form is Form1 and your fields are Field1
and Field2.  Attach the following function to the OnUpdate property of
Field1:

Function UpdateField2()
   If Forms![Form1]![Field1] then
      Forms![Form1]![Field2] = True
   Else
      Forms![Form1]![Field2] = False
   Endif
End Function

For the value to go into the table, it needs to be bound to the table.
In other words, the RecordSource for the control needs to be equal to
the name of the field in the table.

I hope this helps.

John
[e-mail]
=========================================================================
Date:         Sat, 25 Dec 1993 07:51:59 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: On Menu and Modality
In-Reply-To:  <[e-mail]> from "Adam Cohen" at Dec 21,
              93 08:42:48 pm

>
> I have an application with a custom menu bar that is established
> with a menu bar macro and the OnMenu event set for all forms in
> the system.  Everything points to the same menu macro.
>
> The problem is that my first form displayed has to be modal
> and it appears that the OnMenu event doesn't occur until after
> the form is disposed of.
>
> So while the user is looking at the initial form, and until they
> make a selection, they are seeing the default Access menu above
> the form, even though they can't get to it.  It would be nice to
> have my menu show up first.  Is this possible?
>
>   Adam
>
Adam, if the PopUp property is set to true, the OnMenu macro will not
execute on the form.  Make sure it is set to false.  That's all I could
find on this problem.

Good luck.

John
[e-mail]
=========================================================================
Date:         Sat, 25 Dec 1993 20:47:11 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jenny Jacobson <[e-mail]>
Subject:      Re: calculated fields

John asks about having the calculated field stored in the record
rather than being displayed only.

     Maybe I misunderstood the question because the answer is simple.
     Instead of placing the =Date() or whatever expression in
     the bound text box, do the following.

     1.  Double-click the bound text box control.  The detail window
         will appear.

     2.  Enter =Date() or whatever expression in the Default value
         area.

     Jenny Jacobson
     [e-mail]
=========================================================================
Date:         Mon, 27 Dec 1993 15:25:12 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Shameless Plug / VB + Access

I've been away at the Win32 Professional Developer's Conference and catching up
during the
holiday season so my apologies for the lateness of this.

As promised, here is the relevant information for Roger Jennings' latest book:

Database Developer's Guide with Visual Basic(tm) 3
by Roger Jennings; SAMS Publishing
 ISBN:  0-672-30440-6
 $44.95 / 1130 pages
 1 3.5" disk / 5.0 Mg uncompressed

This is another no-nonsense book written specifically for developers -- a good
follow-up to Access 1.1 Developer's Guide.

It should be on store shelves as we speak (or whenever the bookstores recover
from the holiday rush).

phil

---------------------------------------------------------------------
phil paxton
development editor
sams/prentice hall computer publishing  <=== "GO SAMS" via Compuserve
paramount publishing
indianapolis, indiana
317.581.3756
=========================================================================
Date:         Tue, 28 Dec 1993 13:08:11 MET
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         DTN 856-7971 28-Dec-1993 1309 <[e-mail]>
Subject:      Re: administrative note

LIST
=========================================================================
Date:         Tue, 28 Dec 1993 10:12:25 +0000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Willem Robert <[e-mail]>
Subject:      Using read-only database in a multiuser

Hello Access Users !

I access a read-only Access database using Visual Basic in a multiuser
environment.

Every time I open the database (with an OpenDataBase statement in VB), a
file with .LDB
extension is created in the same directory as the database. The .LDB file
contains the
name of the different users logged on the database.

How can I put the read-only database on a network read-only directory if the
.LDB file is
always created in the same directory ?

Or, How can I put the .LDB file on another directory or drive ?

Thanks in advance for any ideas !

Robert.

********
Robert WILLEM at [e-mail]
Network Research Belgium
Seconde Avenue
4040 Herstal
BELGIUM
********
=========================================================================
Date:         Tue, 28 Dec 1993 06:13:52 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Using read-only database in a multiuser
In-Reply-To:  <[e-mail]> from "Willem Robert" at Dec 28,
              93 10:12:25 am

Robert,

According to the Knowledge Base, if you are opening an MDB read-only,
the LDB files are not created.

John
[e-mail]
=========================================================================
Date:         Tue, 28 Dec 1993 07:52:08 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         RAM DIMBA <[e-mail]>

join [e-mail]
=========================================================================
Date:         Tue, 28 Dec 1993 07:55:48 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         RAM DIMBA <[e-mail]>

dir
=========================================================================
Date:         Tue, 28 Dec 1993 11:39:18 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Kenneth Hutchinson <[e-mail]>
Subject:      Updating Fields

 I have a question about updating a single field on a form.
I would like to (at the click of a button) go to a particular
field on that form and increment whatever number is on that
field by one.

 Either a macro or Access Basic would be fine. Unfortunately, I
have no clue how to do this. SETVALUE doesn't seem to work very
well.
------------------
Kenneth Hutchinson
[e-mail]
=========================================================================
Date:         Tue, 28 Dec 1993 15:22:29 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: administrative note
In-Reply-To:  Message of Tue,
              28 Dec 1993 13:08:11 MET from <[e-mail] C.COM>

On Tue, 28 Dec 1993 13:08:11 MET DTN 856-7971 28-Dec-1993 1309 said:
>LIST

Might one ask, list what?
Can I help?

Nathan Brindle
Listowner, Access-L

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Wed, 29 Dec 1993 18:22:13 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Bill Stewart <[e-mail]>
Subject:      Access BASIC - FindFirst

The other night I had a lot of trouble getting the 'FindFirst' dynaset
function to work properly.  My problems seemed to start any time I passed a
argument to my function.

The next few lines will illustrate my errors and fixes.

Enjoy!
-------------------------------------------------------------------------
Function PerformSearch (Search As Long)

        Dim DB As Database
        Dim Found As Integer
        Dim DSTarget As Dynaset
        Dim TString As String

        Set DB = CurrentDB()
        Set DSTarget = DB.CreateDynaset("TableToSearch")

        'The following line produces an error
        'DSTarget.FindFirst "[Field to search] = Search"
        'The next two lines are how to get the FindFirst mechanism to work.

        TString = CStr(Search)
        DSTarget.FindFirst "[Field to search] = " & TString

        If DSTarget.NoMatch = False Then

                MsgBox "Found record"

        Else

                MsgBox "Could not find record"

        End If

        DB.Close

End Function
=========================================================================
Date:         Thu, 30 Dec 1993 15:25:57 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Yen Chin <[e-mail]>
Subject:      Running Macro After Deletes

        This may be a FAQ, but how do you design a form to run a macro or
function AFTER a record has been deleted.  The "On Delete" property
activates the macro BEFORE the record is actually deleted, while the
"Before Update" or "After Update" properties don't seem to activate the
macro when records are deleted rather than changed.
        Is there a simple solution to this, or am I missing something
obvious?  Lot of thanks in advance for any help or advice.

Yen Chin
[e-mail]
=========================================================================
Date:         Thu, 30 Dec 1993 18:16:07 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Access BASIC - FindFirst
In-Reply-To:  <[e-mail]> from "Bill Stewart" at Dec 29,
              93 06:22:13 pm

Bill,

FindFirst takes a string as an argument.  The string corresponds to the
WHERE clause in an SQL statement.  For that reason, the string must
represent either fields in the query, numbers, strings, or dates.  When
you put "[FieldToSearch] = Search", the term Search refers to nothing
that the SQL interpreter can interpret.  When you concatenate in
TString, you have a statement that the SQL interpreter can deal with.

I hope this makes sense.

John
[e-mail]
=========================================================================
Date:         Thu, 30 Dec 1993 18:25:00 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Running Macro After Deletes
In-Reply-To:  <[e-mail]> from "Yen Chin" at Dec 30,
              93 03:25:57 pm

Yen,

To run a macro or function after you have done a delete, the easiest
thing to do is put a button, labled Delete, on your form.  Set the
OnPush property of the command button to your macro/function.  Have the
macro/function do the delete and then run your "AfterDelete" code.

John
[e-mail]
=========================================================================
Date:         Fri, 31 Dec 1993 09:52:00 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         James Mullan <[e-mail]>
Subject:      In-Form Button to send data to Word6 Document: Help, please

I am trying to place a button in an Access Form, which, when clicked:

1) calls up a Word6 document (Fax Cover, Letterhead, etc.); and
2) places data in fields from the Access Form in the document, and

allows me to type further text in the Word6 document, send to printer, etc.
I have Access 1.1, and MS Office 4.0. The Manuals keep referring to "Mail
Merges" "running queries" etc, but all I want to do is to be able to insert
fields from _the current form only_ into the document. It seems a tad
redundant to have to run a Mail Merge or a query to find the data I already
have on my screen ;-)
Is there a workaround available for this rather simple function, or have I
not being reading TFM correctly?
Grateful any help, thanks.

Relatively new subject:
I've been lurking this list for some months now, and find it extremely
valuable, for which my thanks.
Happy new Year!
Jimmy

--
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

"Please don't dominate the rap, Jack, if you've nothing new to say"
(Hunter/Garcia)
"This is the 90s, Bubba. There's no such thing as paranoia; It's ALL TRUE"
(H.S.Thompson)
Jimmy Mullan, who wishes all readers the Best for 1994! :-)
Internet: [e-mail]
++++++++++++++++++++++++++++++++++++++++